3 Replies Latest reply: Jan 3, 2013 9:46 AM by Jonathan Brough RSS

    Columns subtotals in table

      Hello

       

      I would like to have a pivot table like this:

       

       

      Product A

      Product B

      Product C

      SubTotal

      SubTotal

      IN

      OUT

      IN

      OUT

      IN

      OUT

      Product A

      Product B + C

      PT

      ES

      Others

      PT

      ES

      Others

      PT

      ES

      Others

       

       

      Jan

      8

      2

      1

      4

      4

      2

      1

      1

      4

      2

      1

      1

      15

      16

      Feb

      7

      4

      3

      5

      1

      2

      2

       

      1

      2

      2

       

      19

      10

      Mar

      9

      2

      2

      2

      2

      1

      1

      1

      2

      1

      1

      1

      13

      10

      SubTotal 1

       

      8

      6

      11

       

      5

      4

      2

       

      5

      4

      2

       

       

      SubTotal 2

      24

      25

      7

      11

      7

      11

       

       

      Total

      49

      18

      18

      49

      36

       

      The dimensions are "Month", "Products", "IN/OUT" and "Countries" and the respective quantities are given by a sum expression.

       

      For now I've managed to do the majority of the table but i'm lacking the experience to do lines and columns in red.

       

      How can I do the SubTotals columns and lines that I've mencioned above?

       

      Thanks in advance