8 Replies Latest reply: Feb 7, 2013 11:38 AM by Gnana M RSS

    Dynamic % of Total in Trend

      Hi All,

       

      I’ve a trend report which is year month wise trended in pivot chart , Where I’ve two dimensions – Country and year month . For each month ,I need to calculate the current month sales / total of current month sales . Also based on year month filter selection the trend should vary but each month I need a total should be 100 .

       

      I’ve tried with sum(sales)/sum(total sales) but its not working out.

       

      sum(total sales) should varying but I need this to be specific for that month and hence only I can get the total as 100. Could anyone please help me how to aggregate ?

       

      Sales

       

      Country

      201201

      A

      1000

      B

      2000

      C

      3000

      D

      4000

      Total

      10000

       

       

      Sum(Sales)/Sum(total sales)

       

       

       

       

       

      % of total

       

       

       

      Country

      201201

      201202

      201203

      201204

      A

      10

       

       

       

      B

      20

       

       

       

      C

      30

       

       

       

      D

      40

       

       

       

      Total

      100

       

       

       

       

      Thanks,