Pivot Table Problems
Posted by Ben Posaner on May 02, 2001 3:05 AM
Thanks to Mark i'm nearly sorted with my Pivot table problems, but i'm stuck on one point.
I've got a pivot table which has rows of "Date-Hour", Cols of "Group" & is paged by "week" & "band". All works fine And I can change the table by the differbt weeks(5) & the band. (i.e. week 3 & band 100-105) What my problem is that if a certain week doesn't have any data for a group it will miss it out completely. So some weeks i'll have 5 groups & others maybe 3 groups.
I build graphs of these tables and as the number of groups varies so do the number of series & therefore the colors used in the graph.
I've tried ticking the "show items with no data" box, but thia shows all the groups, even though they are not selected in the "Band" dropdown page menu.
Is it pssibel to "show items with no data" but only show those items which are chosen in the "band" dropdown box. (i.e. If the band is 100-105 I want to be able to see 100 101 102 103 104 105, and even if 103 conatins no data, but withou seeing all other non-required groups)
Confused? So am I