Top 100 and full Excel export

[nboccassini]

Hi,

is there a way to make a pivot table that shows only 100 rows, with export button that exports all the rows of the table?

[MK_QSL]

Create Two Different Tables...

One which shows TOP 100 rows based on Rank Function...

2nd which shows all rows...

keep the 2nd Hidden...

Now Create a macro which will export the table to excel... Assign this macro to button and use it for the 2nd chart...

[nboccassini]

The problem is my pivot is big, can this solution reduce the load time of the pivot with the entire data?

[phaneendra_kunc]

Dimension Limits or Max values shown options are available only on straight tables. In pivot table we dont have these options and as once the data is pivoted, not sure how chart can pick 100. Because lets say you have 3 dimensions and one metric and data is pivoted in a chart. Not all the dimension values will have more than 100 all the time right.

if you have to do you have to go with AGGR & RANK as conditional dimension.

What is the reason behind doing Top 100 and Full Export? is it data volume & calculation time of the chart?

Even though you were able to achieve displaying top 100, still for your full export chart has to calculate all the possible values for your dimensions and metrics.