top N rows in a pivot

[sonikajain]

Hi all,

I need to implement a pivot table such that only top 50 rows based upon a third column(not been displayed in the table). Please help me in achieving this.

Thanks in advance

[Miguel_Angel_Baeyens]

Hi,

Are you using version 11? If so, use the Dimension Limits tab in the chart properties, to select those 50 "biggest something".

Hope that helps.

Miguel

[suniljain]

I don't think you can restrict row numbers in Pivot table, better use a Straight table.

May be you can use some calculated dimension for top 10 people or something like that.

[suniljain]

dimention Limit tab is available in straight table . not in pivot table.

[Miguel_Angel_Baeyens]

Hi,

Then you can either use a calculated dimension using Aggr(). Obviously, it will perform not so fast handling huge data volumes i.e.:

=If(Aggr(Rank(Sum(Field3), 4, 1), Field1) < 6, Field1)

In this case you should have to check the "Supress when value is null" in the Dimensions tab

Hope that helps.

Miguel