Total expression

[#1]

Hello everyone, how are you?

I want to know, if is possible make an expresison where each row takes its subtotal value.

Example below:

    Kind regards, Luiz

[kaushiknsolanki]

Try this.

Sum(Total <Item> Sales)

Regards,

Kaushik Solanki

[sunny_talwar]

You mean

Sum(TOTAL <Category> Sales)

[kaushiknsolanki]

Thanks Sunny.

I always get confused here. But this time I got it.

Will try to be correct next time

Regards,

Kaushik Solanki

[#5]

There is a complication, it has to be a set analysis, I mean, the original sum is a set analysis with some conditions, example:

(Sum( Distinct {$< Category-={} >} Sales)/1000)

[sunny_talwar · Accepted solution]

This should work

(Sum(TOTAL <Category> Distinct {$< Category-={} >} Sales)/1000)

[sunny_talwar]

I used to get confused in the past, actually I still do....