Help with CONCAT and Valuelist in a Waterfall Chart
I need to create a waterfall chart that shows the differences between different forecast positions. The chart must show the two forecast positions plus the differences in between across a drill down group.
I've created the two forecast positions, but the difference by brand and region is not calculating correctly as its replicating the overall difference across all dimensions.
I've attached a dummy qvw that simulates my real life issue !
Your parameter eBrandDim will never = Budget or Forecast as it's set up to only be "Brand" or "Region", which means the expression will always default to the sum(Budget)-sum(Forecast) output, which in this case will be 100.
Thanks for taking the time to reply, not sure if I quite follow what you're saying.
eBrandim should change depending on what level we are at in the hierarchy, but irrespective of the level it will always have 'Budget and 'Forecast' as part of the variable result. When I use eBrandDim in a synthetic valuelist dimension and then reference this in the expression the budget and forecast figures calculate correctly. It's the differences across the brand or region which aren't calculating correctly i.e. they're calculating globally and ignoring dimensions.
I've posted a newer app that shows the differences across Brand, this just uses the drill down dimension.
Next to this we have the original table that includes the synthetic dimension.
Instead of showing the individual differences by brand the original table shows the total difference for all brands -260, showing against each brand.
It's got to be something to do with the variable declaration of =eBrand, but if I remove the '=' from this I then lose the brand and region descriptions and just end up with the field name 'Brand' or 'Region' as a dimension.