Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
renjithpl
Specialist
Specialist

Pivot table - Total on the right side using formula

Hi All,

I have a pivot table (pls look at the attachement.)

I want to get the total of SepWeek1-Sep Week4 in the right end of pivot table. I tried adding another expression, but it does not serve my purpose,

i want something like ((pls look at the attachement.) , which would display in one table.

Any Help?

1 Solution

Accepted Solutions
Not applicable

Hi Renjit,

Go to the Prestation Tab Select the State first and then Enable the Sub Total Option.do the same step for the Period also.it will come by default as you want.

Thanks & Regards,

Santhosh Kumar G

View solution in original post

1 Reply
Not applicable

Hi Renjit,

Go to the Prestation Tab Select the State first and then Enable the Sub Total Option.do the same step for the Period also.it will come by default as you want.

Thanks & Regards,

Santhosh Kumar G