How to group this subtotal?

[fionna51]

Hi,

For below TermDen field, I want it to be 12 for all three rows in TERM=1, and 18 for three rows of TERM 2. I must aggregated wrong, please advise, the app attached.

[sunny_talwar · Accepted solution]

Try this

Sum(TOTAL <TERM>DEN)

or this

Aggr(NODISTINCT Sum(DEN), TERM)