Excel Pivot Table Page Field Items

Oct 4, 2012 at 12:15 PM

When a Pivot table is created based on a cube, the page field shows all items of a dimension, and not just those items having values. For example suppose if I have connect Invoice Date in my Sales Fact Table (containg data of only 2011 and 2012)  to a Date Dimension Table (having year from 1975 to 2075). Now when i bring in the Year field at the page level, it shows all the years from 1975 to 2075. However if i drag the field to the rows, it shows only the two years containing data viz 2011 and 2012.

is there any method using the olap pivot table extensions, to enable seeing only those items having value in any attributes at the page level ?

Any help will be greatly appreciated.

Kind Regards

Sanjay Shah, Pune, India




Oct 5, 2012 at 1:51 AM

Unfortunately I don't have any good suggestions for you. The best I can suggest would be:

1. Remove some rows from your date dimension.

2. Use slicers in Excel 2010 instead of page filters. Slicers will visually indicate which members have data. They will also cross-filter with other slicers.

Marked as answer by furmangg on 6/8/2014 at 4:43 PM