Pivot table with Overall total not dependent on di... - Qlik Community

Manish · ‎2020-03-04

Hi Guys

Is it possible to make below mentioned pivot table where i can have a company total at the end along with dimension total

Mandate	Managed	Non Managed	Total
State
A	10	5	15
B	20	6	26
C	30	7	37
Total	60	18	78
Company Total	100	20	120

Anil_Babu_Samineni · ‎2020-03-04

Yes, Please supply the data set to work or explain where did you fail?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Manish · ‎2020-03-04

I used valuelist like valuelist('',Company Total), and used pick and match to write expression but i couldn't strict the dimension "State " like i am able to do for expressions

Brett_Bleess · ‎2020-04-02

Per Anil's comment, really going to need the QVW in order to have a look at things for you to see what may be going wrong. If you have data you are worried about, you can use Settings\Document Properties\Scrambling tab to scramble any fields you wish to mask things.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Pivot table with Overall total not dependent on dimension values