Calculation Condition and System Functions

[sjenkins]

I am trying restrict users to only see a straight table if it returns less than 500 records. I have a Calculation Condition using getpossiblecount which works fine if the user makes restrictions based on various dimensions. However, one of the restrictions in the table is a calculated Dimension which is basically:

If sum(X)<50, null(),1) and then it suppresses the null rows.

This works properly to limit the rows in the table but the getpossiblecount still shows wider universe of records and thus the calculation condition fails.

Is there any way to do a calculation condition that counts the number of rows actually returned in the table?

Thanks,

Steve

[nathanfurby]

In case anyone else stumbles upon this question as I did:

Resolved my issue by putting the following in the Calculation Condition field of the chart properties:

sum(AGGR(Count(PRODUCT_ID),TradeDate,Strategy))<50000

The PRODUCT_ID can represent any populated field in the table.  TradeDate and Strategy are just the Dimensions in the chart in question.  50000 is obviously the row count limit for the chart table.