Sorting stacked Bar chart

[BootCam]

Hi,

I would like to sort the bar chart starting with a particular value in dimension (x-axis) and then the rest will be based on the value in the expression on descending order.

Is this possible? 

Thanks,

BC

[hopkinsc]

Hi

Try sorting by expression and use..

=match(FIELD,'VALUE') and change to descending

That should put the value you have entered at the top and the rest should follow

[BootCam]

Hi HopkinSC,

Actually i am trying to sort by the height(Value) of the Bars not what goes on top or bottom.

Thanks,

BC

[hopkinsc]

Hi, can you give an example?

[sujana1621]

In the sort tab, check the expression box and write your expression for which you would like to sort and select Desc. 

Hope this works.

[BootCam]

Hi Sorry for the late reply.

On the X Axis i have the dimension values like this:

ABC_100_0, ABC_100_1, ABC_100_2, XYZ_100_0, PQR_100_1, DSG_100_2 etc.......

I would like to have the ABC_100_0 first, ABC_100_1 second ABC_100_2 as the third and rest sort doesn't matter.

Please note: the _100_ is a dynamic value

Thanks,

BC