2 Replies Latest reply: Apr 27, 2012 1:05 AM by Manoranjan Ayyaswamy RSS

    Weight expression in multidimensional pivot table

    Manoranjan Ayyaswamy

      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.