Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
dimention Limit tab is available in straight table . not in pivot table.
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