special aggregation functions

[Anonymous]

Hi

I require a special aggregation function, please help -

My data looks like:

Customer     SalesValue     CreditLimit

111               100               50

111               200               50

222               500               100

222               500               100

I have a Pivot table and I want to create and expression for total Credit Limit in Customer Level, which should look like

Customer     Sum of CreditLimit

     total          150

     111            50

     222           100

I tried to do:

Aggr(sum(CreditLimit), Customer)

When I show the Customer Dimension in the Pivot table - everything is fine.

But, when I collapse the Customer dimension - the expression column becomes empty...

BTW - I cannot change the data structure...

Please help ...

Thanks

Yaniv

[MK_QSL]

Only(CreditLimit)

or

Aggr(Only(CreditLimit),Customer)

or

SUM(DISTINCT CreditLimit)

or

Aggr(SUM(DISTINCT CreditLimit),Customer)

[Anonymous · Accepted solution]

Hi

I took a wild guess and tried:

sum(Aggr(sum(CreditLimit), Customer))

it worked

Thanks

Yaniv

[MK_QSL]

Have you tried any of my above suggestions?

I think all will work !

[MK_QSL]

Recheck.... your one is not working !!

[Anonymous]

Just did... works ok...

[arjunkrishnan]

=aggr(NODISTINCT Sum(CreditLimit),Customer)