Sorting measure in columns in Pivot table doesn't work

[Kirsten]

I sorted my column in the table by adding sum([consumed]) to the sorting expression and I get some sort of sorting but it doesn't work properly my numbers go from e.g  160 to 150  to 70 to 130 to 50 to 70

I also don't have any measures under my sorting, which is a bit strange.

How can I just get a normal order 160-150-130-70-70-50, but just for 2019 only. 

see attachment

[jochem_zw · Accepted solution]

Please try Sum({$<Year={2019}>}[Consumer[YTD]]) as a sort expression on your dimension

Not sure if this is what you want.

[Kirsten]

Yes it works thanks 🙂