Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all...
I am working on an aged debt report and have the following fields...
cur_Code - Debt Currency (GBP, EUR etc)
agd_InvoiceBreak - Aged Days (01-30, 31-60, 61-90 etc).
agd_RemainingAmount - Remaining Amount
I have created a Trellis chart with cur_Code and agd_InvoiceBreak as my dimensions and sum(agd_RemainingAmount) as my expression.
What I want to see is the % split by currency for each of the Aged Days (agd_InvoiceBreak).
So each trellis chart in total would come to 100% split along the Aged Days.
What I am getting is the three currency charts coming to 100% in total - hope that makes sense!
I have tried playing about with my formula using the aggr function but have had no success.
Any help greatly appreciated...
Regards
Paul
hei paul
try this example
i changed the expression
hope its helps you
Thanks RoiUser...
=sum(agd_RemainingAmount)/sum(TOTAL <cur_Code>agd_RemainingAmount)
Would never have got this - had been trying...
=sum(agd_RemainingAmount) / aggr(sum(TOTAL agd_RemainingAmount), cur_Code)
Many Thanks
Paul