Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sokkorn
Master
Master

How to add new Total COLUMN in Pivot Table?

Hello,

In the attached file, I have Pivot Table like figure (1).

Then I drag (for pivot) the field Date and Day like figure (2).

Now I need one more Total column like figure (3).

Pleas help to add one more total column (figure 3) on pivot table.

Thanks in advance!

1 Solution

Accepted Solutions
Not applicable

Go to the 'Presentation Tab' , then on 'Dimmensions and Expressions' area, click on fields 'Nationality', 'Date' and 'Day' and select 'Show Partial sums' successively for each of them. It should do it.

Regards.

View solution in original post

5 Replies
Not applicable

If i understood your question properly, "show Partial Sums" in "Presentation" tab will do the job for you.

- Sridhar

Sokkorn
Master
Master
Author

Hi Sridhar,

Thanks for your reply. "Show Partial Sums" in "Presentation" tab is sum by each columns at the Bottom or on the Top row, but what I want is sum by rows (in figure 3).

QV.jpg

Best Regards,

Sokkorn Cheav

Not applicable

Hi,

Any luck with your question Sokkorn? Even i have the same requirement.

Thanks,

Ruby

Not applicable

Go to the 'Presentation Tab' , then on 'Dimmensions and Expressions' area, click on fields 'Nationality', 'Date' and 'Day' and select 'Show Partial sums' successively for each of them. It should do it.

Regards.

Not applicable

Thanks Richard. Its working......