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

# Partial sum total in Pivot Table with Dimensions as CyclicGroup

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?

Sravan

• ###### Partial sum total in Pivot Table with Dimensions as CyclicGroup

Can anyone help with this Issue?

Thanks

Sravan

• ###### Partial sum total in Pivot Table with Dimensions as CyclicGroup

Hi Sravan,

Can you try like this

=If(GetCurrentField(GroupName) = 'Dimension1', Sum(Aggr(Sum(Exp1, Dimension1)),

If(GetCurrentField(GroupName) = 'Dimension2', Sum(Aggr(Sum(Exp1, Dimension2)),

If(GetCurrentField(GroupName) = 'Dimension3', Sum(Aggr(Sum(Exp1, Dimension3)),

If(GetCurrentField(GroupName) = 'Dimension4', Sum(Aggr(Sum(Exp1, Dimension4)),

If(GetCurrentField(GroupName) = 'Dimension5', Sum(Aggr(Sum(Exp1, Dimension5)),

If(GetCurrentField(GroupName) = 'Dimension6', Sum(Aggr(Sum(Exp1, Dimension6))))))))

Hope this helps you.

Regards,

Jagan.

• ###### Partial sum total in Pivot Table with Dimensions as CyclicGroup

Hi Jagan,

Thanks.

Your solution or my solution(Sum(Aggr(Sum(Exp1, Dim1, Dim2, Dim3,..Dim6))) can solve the problem

but for enduser it is not easy or practical when they are making their own charts to use them.

I hope there is an easy way and somebody can help.

Regards

Sravan

• ###### Re: Partial sum total in Pivot Table with Dimensions as CyclicGroup

What a Glitch?! Please use GetObjectField(Dimensionality())