that is actually a very nice solution!
but I am having actually four statuses per region and it is a wish to have a waterfall chart (and I achieved that with different expressions and playing with the bar offset of each expression)
Pardon my ignorance, but how do you create a trellis chart? So that I can see if my waterfall chart would look fine in it?
Look at the attached image.
Go to chart propertied --> Dimension --> Click on trellis -->enable trellis
Capture.JPG.jpg 60.9 K
I really love the outlook of the Trellis chart and potentially works.
As regions though have very different numbers and trellis share the same scale, it is not really feasible for this dataset.
But indeed I will keep it in mind for future reference, thank you Mohammed!
Felim answer is the most applicable to this issue.
thank you both
can you have to sets of data like : TOT and other regions (N, S, W)
so you load table in 2 times
TOT as HeadRegion
From where reigon='TOT
Region as HeadRegion,
From ... wHERE region <>'TOT
and then you can either add a dimension (but still wrong big totals) or let the user select headregion