sort by hidden measure?

[ioannagr]

Hi all,

I have a stacked bar chart, with 3 measures, one dimension.

I want to show only the two  stacks of measure 1 and measure 2 (because measure 1+measure 2= measure 3), but sort dimension by measure 3 without showing measure 3 on the barchart.

Is this possible?

[lironbaram · Accepted solution]

hi ,
yes - 
go to sorting in the property panel , 
select the dimension 
set it to sort by expression 

insert your expression 
and that's it . 
last point make sure the dimension is  first in sorting order 

[ioannagr]

Thank you!!!