1 Reply Latest reply: Oct 24, 2016 2:49 PM by Marcus Sommer RSS

    Pivot table

    José Antonio Albalat



      In a pivot table with 9 dimensiones, is it posible establish subtotals at bottom and the others establish subtotals on top?


      If pivot table don't allow this configurations, is there any extension?



        • Re: Pivot table
          Marcus Sommer

          This isn't possible with native settings of and I doubt that there is an extension with such a functionality. An alternatively might be to add extra TOTAL values to your needed dimensions and query them within the expressions like:


          if Dim = 'TOTAL', sum(total value), sum(value))


          - Marcus