This content has been marked as final. Show 2 replies
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.