Pivot Table - Creating a Restriction in Display of a Dimension
Hi everyone, I have a pivot table which has:
time spanning across the top
a list of systems going down
and an expression sum(impact) which populates the cells.
Is there a way I could possibly limit the number of systems going down to the top 10? I can't seem to find a way in the pivot table. The systems are currently ordered by the descending total of the expression: sum(impact).
Would set analysis in some way solve this problem as when I create the table it shows all the systems available within the selection I have made. Or should I make a calculated dimension?
If you could help it would be much appreciated. Thanks.