4 Replies Latest reply: Mar 4, 2015 8:11 AM by Laura Sébille RSS

    How to calculate subtotal ?

    Laura Sébille

      Hello everyone,

       

       

      I currently have a pivot table looking like this :

       

      City            Product          quantity

      Paris              A                     2

      Paris              B                     1

      London          C                     3

      London          B                     4

       

      City and Product are dimmensions whereas quantity is an expression  (sum(count_s)).

       

      I would like to get subtotal for the city, something like this :

       

      City            Product          quantity

      Paris              A                     2

      Paris              B                     1

      Paris          Total                   3

      London          C                     3

      London          B                     4

      London       Total                  7

       

       

      Thank you for help

       

      Have a good day !

      Laura