Sorting the Inner Segment of stacked Bar Chart

[agnie_john]

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.