Partial sum total in Pivot Table with Dimensions as CyclicGroup

[#1]

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

[#2]

Can anyone help with this Issue?

Thanks

Sravan

[jagan]

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.

[#4]

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

[#5]

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