1 Reply Latest reply: Oct 9, 2017 3:33 AM by Philippe BONNIN RSS

    PIVOT TAB AGGR %

    Philippe BONNIN

      Hi,

       

      I think i have a very classic issue with PIVOT TABLE, but i did'nt found solution for the time being ...

       

      I demonstrate with a sample :

       

      i have this PIVOT TABLE calculating cumulative  % MARGIN

       

      first i calculate from absolute value  : it's working

       

      margin_€.png

       

      Now i want to calculate from relative values.


      So i have to use Aggr ()/total ...

       

      Here my issue : my expression accumulate the values over the periods (Year & Month)

       

      margin_%.png

      i tried also without Dimensionality ()=0

      or with SecondaryDimensionality ()=0

       

      No way :-((

       

      An idea ?

       

      Regards

       

      Philippe

        • Re: PIVOT TAB AGGR %
          Philippe BONNIN

          Hi

           

          I found the solution

           

          It was not a issue concerning PIVOT TAB

          My expression did’nt need AGGR !

          Here is the good expression for my issue :margin_GOOD.png

           

          Sorry for that

           

          on the other hand do you know how to decrease the width of the columns in a pivot table? is it possible ?

           

          Regards

           

          Philippe