Total

[ilanbaruch]

Hi All,

I'm trying to calculate relative amount (pivot table) with excluded dimension :

sum(amount) / sum(TOTAL <item_name> amount)

but result comes as :

sum((amount)/sum(TOTAL amount)

any ideas?

[sasiparupudi1]

try

aggr(sum((amount)/sum(TOTAL amount) ,yourdimension)

[tresesco]

Ideas could be directed to the right direction, if you could attach your sample qvw.