sorting issue in pivot table.

[kishorj1982]

Team,

could you please suggest how to sort the values in descending order as per value in total column.

thanks,

[shraddha_g]

Sort by Expression,

Put Expression for Total in Expression box and put descending order

[Anil_Babu_Samineni]

Chck this

[kishorj1982]

Hi,

But in your file month are not in order from most recent month to least recent month.

Regards

[Kushal_Chawda]

use below in Sort ->Expression

=sum(aggr(pick(Match([Not Paid in Last],'3 months','6 months','9 months','1 Year','> 1 Year'),Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -2), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver),  Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -5), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver),  Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -8), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver),  Sum({<AR_CustomerLedger.MonthYear ={">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver),  Sum({<AR_CustomerLedger.MonthYear ={"*"}-{">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver)  ),AR_CustomerLedger.MonthYear,AR_CustomerLedger.CustomerName)) 

[karthikoffi27se]

Hi Kishore

Use =Match ([Not Paid in Last],,'3 months','6 months','9 months','1 Year','>1 Year)

That will sort according to the field.

Many Thanks

Karthik