Discussion board where members can get started with QlikView.
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 :
Expression : Outstanding Cash
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 ?
Go to Solution.
Chart Properties, Style, Check Indent Mode check box.
Thank you so much.
Perfect, It works.
Thank you so much...