Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try
aggr(sum((amount)/sum(TOTAL amount) ,yourdimension)
Ideas could be directed to the right direction, if you could attach your sample qvw.