Maybe somebody had already the same issue (I'm sure :-))
I want to create a Waterfall Diagramm. Starting on the left with total Budget and ending on the right with total Actuals. Between there should be the difference by customer or by product category.
How can I avoid that Totals for Actual and Budget get split by the dimensions?
Thanks for your help
What I need is a split by dimensions (for example Customer or products) only of the "Vario"-Data.
The issue is that for Actual and Budget there is also this split by Dimension available. As it does'nt make sense to show the gap between budget and actuals for every dimension I want to show the total of Sales and Budget, but for Vario the split by dimension. There must be a formula or something that dimensions are only visible for "Vario"...
hope this helps...
This happens when I just enter a Dimension (product) ==> doesn't make sense....
What do you mean with 'blocked properties'. I'm afraid I don't understand your question.
You can see the script by 'file - edit script' or CTRL+E.
You can see the chart properies by right clicking on the chart. Under expression, tou will find 'sum(value)' as expression and if you click on the plus sign left of the expression, you can also see the 'bar offset' expression 'RangeSum(above(sum(value),1,100))'.
Is that you question ?