I'm trying to calculate relative amount (pivot table) with excluded dimension :
sum(amount) / sum(TOTAL <item_name> amount)
but result comes as :
aggr(sum((amount)/sum(TOTAL amount) ,yourdimension)
Ideas could be directed to the right direction, if you could attach your sample qvw.
Retrieving data ...