Waterfall charts - ordering

[former_member997199]

Hi, I have a simple waterfall graph

measure = revenue

2 Dimensions = version & customer

Time is filtered dynamically to the month

For the version I use Actual and budget, customers being the waterfall effect.

The waterfall graph defaults to actual being bridged to budget. As my actuals are higher than budget, what should be an increase in customer revenue is being shown as negative. How can I flip to start with budget to show an increase in revenue?

You see in the image Actual >actual Py when it shoudl be the other way around.

I have a feeling it the charts defaults alphabetically, which makes no logic.

Thanks

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

Keep in mind, when you receive an answer that was helpful to you, accept it as best answer.

Best,

Your SAP Community moderator

[Jay_Gandhi]

Hi darthmortel1980,

Your last comment indeed is unfortunately the behaviour; versions are alphabetical.

What we've done in the past to workaround this issue is to create Versions with a . (PERIOD) in between to have it appear first, 'DOT Versions so that the version display before Actual'. Example .Budget will appear before Actual.

Jay

[former_member997199]

Thank you for the swift response. We only have 5 versions

Actual prior year, Budget, Prior Forecast, Current Forecast, Actual,

Would this work?

.Actual prior year, .Budget, .Prior Forecast, ..Current forecast, Actual

Alternatively

1.Actual Prior year, 2.Budget, 3.Prior Forecast, 4.Current forecast, 5.Actual

Thanks again

[Jay_Gandhi]

Hi there,

Yes please be mindful of the Period/Dot approach ahead of any Versions referencing 'Actual'. It will take the . into account then # and then alphabet if that makes sense?
Thanks.

Jay