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

    Pivot table

    Albalat José Antonio

      Hello,

       

      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?

       

      Thanks,

        • 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