Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
If(Dimensionality() = 1, Count(DISTINCT ITEM)/Count({<SWITCH={1}>}SWITCH), Count({<SWITCH={1}>}SWITCH))
Attached QVW
Please help .
May be this
If(Dimensionality() = 1, Count(DISTINCT ITEM)/Count({<SWITCH={1}>}SWITCH), Count({<SWITCH={1}>}SWITCH))
Thank You Sunny Bhai .
Is there any way for Labels .. like TOTAL FOR T1 , TOTAL FOR T2 etc ......