Encounter problem in Sort in Pivot table

[Anonymous]

Hi All

My below 2 expression work fine :-

AGING_ =

var _datediff=Datediff([AR Invoice Date],today(),day)

return

SWITCH(

TRUE(),

_datediff<=30,"1 to 30 Day",

_datediff<=30,"31 to 60 Day",

_datediff<=61,"61 to 90 Day",

_datediff<=91,"91 to 120 Day",

_datediff<=120,"121 to 150 Day",

_datediff<=151,"151 to 180 Day",

_datediff<=181,"181 to 210 Day",

_datediff<=211,"211 to 250 Day",

_datediff<=251,"251 to 270 Day",

_datediff<=271,"271 to 300 Day",

_datediff<=301,"301 to 330 Day",

_datediff<=331,"331 to 360 Day",

"Over 361 day"

)

AGING Sort_ =

var _datediff=Datediff([AR Invoice Date],today(),day)

return

SWITCH(

TRUE(),

_datediff<=30,1,

_datediff<=30,2,

_datediff<=61,3,

_datediff<=91,4,

_datediff<=120,5,

_datediff<=150,6,

_datediff<=180,7,

_datediff<=210,8,

_datediff<=240,9,

_datediff<=270,10,

_datediff<=300,11,

_datediff<=330,12,

_datediff<=360,13,

14

)

But when i try to create pivot table , i cannot sort by AR Aging Period.

https://www.dropbox.com/s/dki63npflq8wwsv/PBT_V2021_89%20SORT%20BY%20AGING.pbix?dl=0

Paul

[amitchandak · Accepted solution]

@Anonymous , Have you marked the sort column correctly. Because in matrix column( Pivot) only sort column or natural sort will work.

Refer to my video on this -https://www.youtube.com/watch?v=KK1zu4MBb-c