Sorting within a pivot table from the smallest to the largest values

[the-null]

Hello, I want to create a button by dimensions that, when pressed by the user, will filter a field from the smallest to the largest values.

Can somebody help me with that 🙂

[Chanty4u · Accepted solution]

Try this way.

Dimension:

=AGGR(FieldName, DimensionName)

Measure on which filed you want to sort you can use accordingly

=AGGR(Sum(Sales), Category)