4 Replies Latest reply: Sep 28, 2012 5:50 AM by Sem Art RSS

    Partial sum total in Pivot Table with Dimensions as CyclicGroup

    Sravan Puppala

      Hi Guys,

       

      I have this problem as below in the following thread.

       

      http://community.qlik.com/message/189400#189400

      Thanks to stefan

       

      I know it gets solved with AGGR as explained in the thread. My Question is if I have a cyclic Group as Dimension containing 6 Dimensions(Dim1...Dim6) grouped,

      I can't always write in my Sum(Aggr(Sum(Exp1, Dim1, Dim2, Dim3,..Dim6)) everytime I create a  chart for Partial sums.

      Is there any other way when using Cyclic Group as Dimension?

       

      Thanks in advance

      Sravan