Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart which includes only dimensions.
It has 25 dimensions and 60K rows.
It is very heavy and takes 30 sec to load.
We want to limit it for 500 rows only for the load to layout with possibility to extract ALL the data (60K rows) to excel file.
How do I do it?
Thanks,
Inna
Hi Chanty,
I need some solution like in the second example:(Limit # of Rows in chart(Pivot Table), but honestly did not understand what I have to do.
Anybody can help me?
Can you share a sample to look at your issue?
Add the calculation condition on the chart Object and force to users to select the selections until chart get 500 rows only.
The solution below counts "rows" based on the table which contains the dimension used in count(). You may need to adjust which field you use in count() depending on your data model.
A. Limit rows in pivot table:
One way is below:
B. To export all rows
One way is dynamically set the number used in the calculation condition. You can do this with an input box. Instead of hard coding a number in the calculation condition you can base the rows on the variable tied to the input box. To export all/more data the user can change the max # of rows by setting the value in the input box. You can also use a predetermined list of values or an additional condition in your calculation condition to control the max #.