469,898 Members | 1,511 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Pivot table not showing blank value column ...

I am facing problem like;

We generate reports thru Excel Pivot table. The data is coming from sales
cube. Let?s assume that there are 2 products A and B. The user wants to
filter for each product and view ?stock in hand? and ?total sales? for
particular month (as two columns).

From the Pivot table filtering, when we choose product A and month ?Jan?,
it is showing values for ?stock in hand? and ?total sales? columns for that
month.

But when we choose product B and month ?Jan?, it is only showing ?stock in
hand? value and the ?total sales? column was suppressed/unseen. We know
that there is no sales transaction for ?Jan? month. But we still want to
show the column title even if there are no records in the database / cube.

I am not using any scripting, this pivot table was generated just thru
Pivot table wizard.

Any way to achieve this, please advise me.

Advanced thanks for u r help.

--
Message posted via http://www.sqlmonster.com
Jul 23 '05 #1
0 1682

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Bajal Mohamed via SQLMonster.com | last post: by
reply views Thread by EddieA | last post: by
3 posts views Thread by Jerry K via DotNetMonster.com | last post: by
1 post views Thread by kingster | last post: by
1 post views Thread by jodyblau | last post: by
9 posts views Thread by PeteCresswell | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.