Limit by the Number of Rows

[melissapluke]

Hi all,

I am using a table in which the users can pick the dimensions and measures shown in the table. I'd like to add a calculation condition to limit the table to a certain number of rows, but because the user can pick from a variety of dimensions/measures, there isn't a specific dimension i can use the do something like "Get Possible Count". Does any one have any ideas of what I can use as a calculation condition to limit the table?

Thanks!

Melissa

[sunny_talwar]

Are you only going to pick one dimension at a time or can you also pick multiple dimensions?

[melissapluke]

It can be up to about 50 different dimensions that can be selected.

[sunny_talwar]

And all of these are getting selected from a dimension which is created using an Island table? If it is, may be you can do this

Count(DISTINCT $(=Concat(DISTINCT '[' & DimensionName & ']', '&')))

[balabhaskarqlik]

May be limit the load of rows by condition base:

if(sum(aggr(1, DimA, DimB, ..., DimX)) < 100,1,0).

or

Count(Aggr(1,$(=Concat(Dim,',')))) < 100