3 Replies Latest reply: Oct 11, 2012 12:26 PM by Pritam Dey RSS

    Calculating from dynamic columns in pivot view

    Pritam Dey

      Hi,

       

      I am trying to use pivot view to get a report in a desired format.

       

      Initial Pivot Table:

       

      Name                ||      Date      ||      Value

      A                            1 Oct                    40

                                    2 Oct                    20

                                    3 Oct                    50

      B                            1 Oct                    30

                                    2 Oct                    10

                                    3 Oct                    60

       

      I pull the date above to the columns to have a view like this:

       

      Name Date      1 Oct     2 Oct     3 Oct

      A                    40          20          50

      B                    30          10          60

       

      How do I get an % with respect to total value of the names for that date, i.e when name is A and date 1st Oct the desired value is 40/(40+30) = 0.5714

      A on 2nd Oct =  20/(20+10) = 0.66