Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team,
could you please suggest how to sort the values in descending order as per value in total column.
thanks,
Sort by Expression,
Put Expression for Total in Expression box and put descending order
Chck this
Hi,
But in your file month are not in order from most recent month to least recent month.
Regards
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))
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