Hi all,
In Forecast app I've got conditional display so that the user can choose to display objects by Weighted or Unweighted data.
It goes like this:
in the script:
LOAD * INLINE [
AmountType, AmountTypeDes
1, Weighted
2, Unweighted
];
so the user can choose display by Filter Pane:
and in objects expression:
if(if(SubStringCount(Concat(AmountType,'|'), '1') =1,1,2)=1,sum(WeightedAmount),sum(UnweightedAmount))
NOW, this condition works just fine in most objects, BUT it's not working in Bar Chart with two dimensions.
For example, there is a "Region Amount by Year" Stacked Bar Chart with two dimensions: Year and Region, and the expression above.
but, it's only display sum(UnweightedAmount) values while it's not responding to display choice that made by the Filter Pane (Weighted/Unweighted).
Why so?
Thanks in advance,
Aviad