Hello,
I have pivot table with the following coulmns (attached example):
User, Vendor Num , Vendor Name , Date , Oreder Num , Amount
I want to sorting the table by the totals of field amount (expression field) group by User,Vendor Num , Vendor Name , Date.
The field that exists in sort Tab are (attached): Order Num , User , Vendor Num , Date , Vendor Name.
I have tried to insert in sort by Expression :
Aggr(Sum({<Year=>} OrderAmount_$(vCurrency) ) /$(vPrecision) ,User,Vendor Num , Vendor Name , Date)
But it doesn't sorting...
Could you please advise?
Thank you!
