Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have two dimensions which one of them is office names and the other one is years. I calculated the sum of sale amount of each office name in each year in expression column . How can I have the differences sale amount between two years ( current and previous year) in one office ?
Note: 92 and 93 are years
Hi,
Please find attached file for solution.
Changed Dimension and expressions.
Regards,
Jagan.
Hi,
No need to calculate for office separately.
Just add office to your dimension.
Can you post sample app with expected output to help you out further.
Regards
ASHFAQ
I have already office names as one of my dimensions . yes sure I have a sample app to post but I dont know how to do this here
Thanks in advance
When replying click Use Advanced Editor and the Attach will appear.
Thank you
This is my sample app
Hi,
may be like this.
You can modify formula as required.
Regards
ASHFAQ
Hi,
Please find attached file for solution.
Changed Dimension and expressions.
Regards,
Jagan.
This is exactly what I want Thank you so much !
Hi,
If you got the solution please close this thread.
Regards,
Jagan.