Help with Trellis Chart

[pkelly]

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

[lironbaram · Accepted solution]

hei paul

try this example

i changed the expression

hope its helps you

[pkelly]

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