Limit Straight Table Row

[#1]

Dear all,

I have problem with straight table. There are too many rows and column causing the object memory error.

May i know the way for me to limit the number of rows to be displayed as users are not keen to see all rows after they click clear all.

This is to prevent the object memory problem. I saw some ppl use calculation condition like count(id)>10000. But it doesnt work for my straight table. Thank you

[Gysbert_Wassenaar]

Try something like =sum(aggr(1, Dim1, Dim2, ..., DimN)) < 10000 as calculation expression after replacing Dim1, Dim2, ..., DimN with the names of the dimensions in your chart. If you're using calculated dimensions you''ll have to add the dimensions used in the calculated dimensions.