Detect the last group in a crosstab

[Ken]

Hi, 
I need to use a special expression in the last group in a table. The first row I can detect by using

RowIndex("crossTab1") = 1

I want to use the same logic to detect the last group, but I can't find any indications of number of groups in the table or number of rows in a group (other than using COUNT aggregate).
I have now found a way to solve it by using

RowNumber("crossTab1") = EXEC("crossTab1", CountDistinct(Fields.Month))

However I feel that it is ineffective to count all rows in all groups. Is there a better way to accomplish this?

 

Best regards,

Anders

[Nasko]

Hello Anders,

There isn't another global object/specific function other than the Count/CountDistinct aggregate which will return the number of group rows in the current group. Thus, your approach to compare the row number with the month count is the recommended solution.

Regards,
Nasko
Telerik