Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have calculated % for particular filed in measure and got around 20 % values.
But these values are not in order like 5%,1%,70%,30%
I want to display % values of the measure in order like 1%,2%,3%...
how can i sort the measure values?
Is this a dimension or expression?
it's a measure
and measure calculated by expresion
So, you are unable to sort by measure? Can you share an image of the sorting order for dimensions and expressions?
it's measured in a pivot table.
In sorting section, I'm not getting a measure values only rows and columns fields are displaying
oh okay... make sense.. would you be able to share a sample to see and test out?
What happens if you use the "Sort by expression" and put in your measure expression (I think this is what you look far, as far as I understand)? As Sunny point out, please post a sample to test
Furthermore... take a look at this topic Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)