Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone please help me out to develop the below chart which is shown in the excel. I have already prepared the one which is highlighted in yellow. Can you please help me out to prepare rest of the stuffs.
FYI, Monthly, Average and Comparison can be separate table. Measure which is there in the Average and Comparison table should work based on the date selection(So it should be dynamic).
Also this has been created based using the pivot table.
Please let me know if you have any questions.
Hello!
Add one more table in the script:
After that you'll be able easily offset sum() or avg() functions with Set Analysis:
I've rounded values so there a little difference with your xls.
Thanks will check and update you... Currently don't have access...