Welcome to the Forum.
I'm not sure if this is quite right, but please see if this can give ideas.
As you said, it is all about the table calculations.
The difference for a brand from one month to the next is:
ZN(SUM([Exc.Cost $ (M.USD)])) - LOOKUP(ZN(SUM([Exc.Cost $ (M.USD)])), -1)
( I simply dragged the quick calculation pill to the Measures pane).
To do so, I moved the Date(Months) to the Detail shelf.
Running Total became:
Then the critical part is the settings for the table calculation
(not sure if I got them quite right) as shown below.
Please see workbook v18.1 attached in the Forum Thread:
286601waterfall.twbx 1.8 MB
Many thanks Swaroop Gantela,
This solution would be perfect except for the fact I cannot then sort by your new calculation fields. For some reasong it works in the test enviroment, but when I tried to replicate this into my actual data, the sort is disabled for all calculated fields that I have replicated from your file.
Again, many thanks and please let me know
Could you describe more the dimension that you are seeking to sort,
I think it is represented as Brand ID in the test set? That is, is it
a calculated field or is it coming straight from the datasource?
If a calculated field, could you post its equation?
There are other methods of sorting other than using the right-click sort pop up.
Not sure if it will work for your setup, but it would be putting a discrete copy of
the sort-by-measure to the left of the dimension in question:
Would be grateful, if permissible, if you could post a screenshot of your worksheet,
including the pill locations on all the shelves. You could blur out anything you don't want visible.
Thank you so much for helping me with this....
I don't think this is going to help me actually.... I have re-posted another question, where I attached an excel as the actual example - Called "Waterfall Chart"
It didn't let me attach an excel to this, that is why I had to start over
Let me know if you can help me with this