January 6, 2014 at 6:40 am
For the purposes of obfuscation, imagine you have a cube where we track a survey of reported favorite colors over time. There's a date dimension and a color dimension and our facts are the reported favorites. Within the Color Dimension, we have broken down the colors into two groups, primary (i.e. red, yellow, blue) and non-primary (everything else).
Now we have an Excel spreadsheet connected to that cube and it looks like this:
All ColorsPrimary Colors
Favorites CountColumn Labels
Row LabelsRedYellowBlue
2013 915634
February4734
October4
November79
December566
Grand Total915634
Filter: Primary Colors only
Rows: Dates
Columns: Colors
Values: Favorites count
There's a drop-down arrow next to Column Labels that allows you to filter the column headers. But when you click on it, you get every color in the entire world (Mauve, Indigo, Sunset Breeze) and we only want to see the list of colors with respect to the Primary Colors filter. Is there any way to do this? i.e. get the Column Labels list to respect the filter as included in the Pivot.
January 6, 2014 at 6:47 am
You can achieve this functionality when using slicers instead of filters.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 6, 2014 at 7:02 am
Thanks for the speedy reply, Koen. Slicers do present a nicer visual display option, but they don't seem to filter the Column Labels all on their own. The slicers plus simply hiding the Row Label/Column Label options in the PivotTable properties might be an adequate solution. The goal here is to prevent end-users from stumbling into an exceedingly long list of dimension members.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply