Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
Thank you for the guidance.