4 Replies Latest reply: Jun 24, 2014 6:32 AM by Bruno Souza RSS

    New subtotal

      Hi,

      I need to create two new rows "total" in the positions that I have indicated in the figure. The table is a table pivots.

      The totals must be calculated in the following way:

      Total (101,102): 1500+2590 = 4090

      Total (201,202,203): 850+450+800 = 2100

      How can I do?

      Thanks!

       

      Immagine.png

        • Re: New subtotal
          Sundarakumar Kalaimani

          U can do it if 101 and 102 belong to another hierarchy like 100 and 201,202,203 belongs to the 200 in the same level. I mean if u have data as below.

           

          100     101

                      102

           

          200     201

                      202

                       203

           

          If u don't have hierarchy as shown try to create one with some business logics, since u look interested in summing 101,102 and 201,202,203. If u don't have such level then I thinks its hard.

          Once u have that level created u have the option in presentation tab. otherwise I guess it is not possible in Pivot table.

           

          Regards,

          Sundar

           


          • Re: New subtotal
            Bruno Souza

            Hello, Marco

             

            You can use a calculated dimension with a expression like

             

            =Floor(cdc, 100)

             

            or

             

            =Left(cdc, 1)

             

            Put one of those expressions as your first dimension and turn on subtotals for it.

             

            Hope it helps.