Totals in RTC calculate hidden rows due to grouping

Dekito

Hi everyone,

As the subject says, I'm calculatin totals in details rows in a table in RTC.
I have used grouping on the details of the tables which hides some of the
rows (duplicates) but the total calculates fields from them, anyway.
I'm using the Sum() function.

Does anyone know how this can be handled and calculate ONLY VISIBLE fields
and not hidden (DUE TO GROUPING, NOT HIDDEN ATRIBUTE).

10x in advance

mohana_cse06

You can take a variable and calculate based on the same condition through coding..