I have been trying to sort a pivot table, which has 4 dimensions and 4 expressions.The pivot calculates total ageing and its distribution in 3 ageing buckets.
Now, i have been trying to sort the ageing based on "Location" column using below sort expression which is same as Ageing formula:
= if([AP_ Status] = 'A' and (APStatus = 'P' or APStatus = 'Q'),