Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello to all of you,
i have a little problem to show the total Value from Last Year. I have the following table:
I want to show for the selected Year and Month all Days. For the current selected Year there should be shown the daily sale. So the column "CY" is correct. Now i want to create a second column "LY" which should contain the total Sale from last year with + X Procent for calculated value for each day. But every time the Dimension change to the last year date. But i want only the selected year days as dimension and in the column the total with X percent.
So in LY should be for every day (04.01.2016/05.01.2016 etc.) the total value 13.212.963,26€.
Can anyone help me?
Thank you
What is your current expression for LY? You need to add something like this:
If([CY] > 0, Sum(TOTAL SalesForLastYear))
The key here is to add TOTAL in your expression for LY and add an if statement to make LY's row null by checking if the CY is greater than 0 or not.