Create expression when expression 1 is higher than expression 2

[loke2014]

Hi,

I have created a straight table with 2 total sales expressions as below:

(a) Current month with dimension =Product 1, Product 2, Product 3, Product 4

(b) Previous month with dimension =Product 1, Product 2, Product 3, Product 4

I would like to create a third expression whereby it is populated with the difference between current month and previous month total sales by product as dimension in a new column.

Any idea how this can be done?

Thanks.

[swuehl · Accepted solution]

Product is your dimension?

Then just use something like

=Column(1) -Column(2)

or rewriting your original expressions, e.g.

=Sum(Sales) - Sum( {<PrevMonthSetAnalysis>} Sales)

[loke2014]

Thank you for the guidance.