Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In table chart i have to calculate difference in percentage.
In table chart i have year as dimension then in second column i am calculating sum(Sale) for May month, in third column i am calculating sum(Sale) for Apr month, and at fourth column i need to calculate percentage difference.
What are the expression for Apr and May Sales?
Hi,
and your question?
You probably want something like that:
(sum({1<Month={'May'}>}Sales)-sum({1<Month={'April'}>}Sales))/sum({1<Month={'April'}>}Sales)