How to manipulate Total Value in Pivot Table using using show partial sum ?

[shekhar_analyti]

Hi All ,

I am not sure about How to manipulate Total Value in Pivot Table using using show partial sum ?

DATA 

LOAD * INLINE [
ITEM, SWITCH
A, 1
B, 0
A, 1
D, 0
A, 1
B, 0
A, 1
D, 1
A, 1
B, 1
A, 1
D, 0
A, 0
A, 1
B, 0
C, 0
D, 0
A, 0
B, 1
A, 1
A, 0
A, 1
B, 0
B, 0
C, 1
Q, 0
B, 1
D, 0
R, 0
E, 1
A, 1
B, 0
C, 1
D, 0
A, 0
B, 0
A, 1
C, 0
Q, 1
A, 1
B, 1
R, 1
R, 0
Z, 0
B, 0
C, 1
D, 0
A, 0
B, 0
A, 0
C, 1
Q, 1
A, 0
B, 0
R, 1
R, 0
Z, 1
B, 1
C, 0
D, 0
A, 0
B, 0
A, 1
C, 0
Q, 0
A, 0
B, 0
R, 0
R, 0
Z, 1
B, 1
C, 0
D, 1
A, 1
B, 1
A, 0
C, 0
Q, 0
A, 0
B, 1
R, 1
R, 1
Z, 0
B, 0
C, 0
D, 1
A, 1
B, 0
A, 0
C, 0
Q, 0
A, 0
B, 1
R, 0
R, 1
Z, 1
B, 1
C, 1
D, 0
A, 1
B, 1
A, 1
C, 0
Q, 0
A, 1
B, 1
R, 1
];

LOAD * INLINE [
ITEM, GROUP
A, T1
B, T1
C, T2
D, T4
Q, T6
R, T6
E, T7
Z, T6
];

Thanks & Regards

Shekar

[shekhar_analyti]

Attached QVW 

[shekhar_analyti]

@sunny_talwar 

Please help .

[sunny_talwar · Accepted solution]

May be this

If(Dimensionality() = 1, Count(DISTINCT ITEM)/Count({<SWITCH={1}>}SWITCH), Count({<SWITCH={1}>}SWITCH))

[shekhar_analyti]

Thank You Sunny Bhai . 

Is there any way for Labels .. like TOTAL FOR T1 , TOTAL FOR T2  etc ......