Sum Total with multiple conditions

[arvinserco]

Hi all,

Row Labels	Negative	Positive
AA	-2400792.828	567974.053
BB	-318395.583	24996.186
CC	-7764599509	176429.394
Grand Total	-7767318697	769399.633

I need to calculate the percentage of each "row labels" out of Grand Total  for both Negative & Positive Category. Also I need to use the filter as "Class1" from one of the column's (by using which I get the above Data table). I need to put all these conditions in one expression.

If anyone can help let me know.

[sunny_talwar · Accepted solution]

Try this

For Positive: Sum({<Margin={'Positive'}, Region = {'Class1'}>}sales)/Sum({<Region = {'Class1'}>} TOTAL <Margin>Sales)
For Negative: Sum({<Margin={'Negative'}, Region = {'Class1'}>}sales)/Sum({<Region = {'Class1'}>} TOTAL <Margin>Sales)

[arvinserco]

Thank you so much Sunny... Great Help... It works. 🙂