Set analysis - specific field

[hjm35055]

Hi,

I'm trying to create a formula that is...

sum(Revenue)-sum(OtherRevenue) where field (or dimension) is LOB.

Thank you!

[devarasu07]

Hi,

Try like this,

Expression:

sum({<dimension={'LOB'}>}Revenue)-sum({<dimension={'LOB'}>}OtherRevenue)

Hope this helps you

Regards,

Deva