Hi,
I am trying to sort the inner segment of the stacked bar chart.
I used an expression in the dimension for Bar
=DUAL(Customer,AGGR(Sum(Sales),Customer,Area))
and able to sort the inner segment.
but i would like to use this logic for chart with alternate dimension.
Based on the user selection i use GetObjectDimension(0) to get the first and second dimention and use the expression based on the selected dimension.
DUAL(Area,
If(GetObjectDimension(0)='Area',AGGR(Sum(Sales),Area),
If(GetObjectDimension(0)='Plant',AGGR(Sum(Sales),Plant,Area),AGGR(Sum(Sales),Customer,Area)
)))
The above expression doesnt work for me.
Can i use GetObjectDimension in the Dimensions?
Thanks in advance,
John.