Sorting pivot by measure only max Year, or max month or max Year-month etc.

[waszcma1]

Hi could you help me create the right expression to sort data in pivot table

At the moment I am using SUM(Ammount) in sort by Expression [Descending]

But it works only on total or only for one year selected

I would force sorting always on the last period visible in the pivot table in this example 2019 amounts should sort the records.

There are also hidden view for different periods like Year-Quarter, Year-Monht, Quarter, Month 

[tripatiqv]

Hi,

Please share the sample application

[waszcma1 · Accepted solution]

HI,

I think i have found solution:

To sort pivot by only latest year I need to use Set analysis in sort by expression:

sum({<Year={$(=max(Year))}>}worker_cost)

Similar for others periods but always just take only max of the displayed period 

[favio220]

Excellent!

Thank you.