Is there an easy way to filter data inside of a PivotTable that uses OLAP as
the data source? We have a Location dimension:
and a calculated measure Compliant (integer sum), indicating meeting
compliance with quality standards.
The current PivotTable presentation is flattened (by Hiding Levels) to only
show Location Names and Compliant (ranging from 0 - 7 in value). I would
like to only show the names that have a compliance value equal to 7.
Can this be done in the PivotTable? If not, what do I need to change in the
cube? Do I use a Partition?