Weight expression in multidimensional pivot table

[manoranjan]

I have a requirement to show weightage of Sales for each product within a Region/Country/State. In other words contribution of each product in Total sales for that dimension. In a straight table, it is very easy to this... by "selecting" the "Relative" checkbox for this expression.

But in a pivot table there is no "Relative" checkbox. As an alternative, in one of the discussions, it was mentioned to use the below

Sales/Sum(Total Sales) ... this works for a single dimensional pivot table. But in multidimensional pivot, the Sum(TOTAL Sales) actually aggregates the total sum of all products across regions, states.

I created a test document for the same. Someone kindly help me fix this.

[swuehl · Accepted solution]

You can actually use a field list with TOTAL qualifier, so try:

sum(Sales)/sum( total<Product> Sales)

[manoranjan]

Thanks swuehl, I guess thats exactly what I want. Will try in the main dashboard now.