Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to qlikview and using pivot table first time .
How can I get the SUM of Outstanding cash , If I collapse to FinMGR or DirSFS or SrDirSFS in pivot table .
My dimensions of Pivot table are :
SrDirSFS
DirSFS
FinMGR
FC
StudentID
Expression : Outstanding Cash
Example:
SrDirSFS | DirSFS | FinMGR | FC | StudentID | Outstanding Cash |
---|---|---|---|---|---|
Neilly , Donna | Neilly,Team | Harrington, Boyd | Evangelo,Tanya | 10111100 | $ 100 |
10222211 | $ 200 | ||||
10333322 | $ 125 | ||||
Paradis Jason | 123456 | $ 200 | |||
1117777 | $ 300 | ||||
Jones , Jeffrey | Kristine | 0000001 | $700 | ||
11111223 | $ 250 | ||||
77788899 | $ 50 | ||||
From Above table I want to show
1) SUM by FC :
Evangelo,Tanya = 100 + 200 + 125 = $ 425
Paradis , Jason = 200 + 300 = $ 500
Kristine = 700 + 250 + 50 = $ 1000
2) SUM by FinMGR :
Harrington , Boyd = 100 + 200 + 125 + 200 + 300 = $ 925
Jones,Jefferey = 700 + 250 + 50 = $ 1000
3) SUM by DirSFS :
Neilly , team = 100 + 200 + 125 + 200 + 300 + 700 + 250 + 50 = $ 1925
Follow the attached qlikview document to understand my question .
Is there a way to see the Totals in Pivot table as per above example ?
Thanks.
sum(Outstanding Cash)
Chart Properties, Style, Check Indent Mode check box.
sum(Outstanding Cash)
Chart Properties, Style, Check Indent Mode check box.
It works.
Thank you so much.
Perfect, It works.
Thank you so much...