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.
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)
