Pivot Table - Creating a Restriction in Display of a Dimension

[#1]

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.

[#2]

Hello

Try something like this in u r dimensions

=If(Aggr(Rank(Sum(impact),[systems ])<11,[systems ],'All Other ')

and keep the other same as it is

It should work

Talha

[#3]

Hi Talha,

Thanks for your response. I've tried that expression but I get the 'error in expression' comment. I think there may be a problem with the brackets but i can't see what it is!

[#4]

Can you send me the exact Field names or else one application with the mockup data in that.

Talha

[#5]

Fieldnames:

Date: MonthYear

The column from top to bottom is: SystemName

Expression: sum(Impact)

Regards

[#6]

Try this out

=If(Aggr(Rank(Sum(Impact)),SystemName)<11,SystemName,'All Other ')

This should work

Talha