Hello everyone,
I’m currently working with a pivot table and facing an issue with sorting based on a measure.
Current situation:
When I try to sort the data in ascending or descending order, the sorting doesn’t work as expected—even though I’ve added the same dimension at all three levels.
Desired result:
The data should be sorted correctly based on the selected measure. For example, in ascending order, it should display values like: 11.43, 14.75, 15.43, 17.08, 17.14.
Hi @rishisri , welcome to the QS Community.
The problem here is that in this case, using a Pivot, when you select sorting by a specific field, it will sort by grouping fields.
In this case you have one element per group, so the sorting seems wrong:
If we have more than one values per group, you’ll see that the sorting will work for each group:
With the pivot and the grouping, you cannot have sorting outside a specific group.
Is a Pivot Table strictly necessary in your case, or can you go with a normal table?
Andrea
