Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Sokkorn
Honored Contributor

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

How to add new Total COLUMN in Pivot Table?

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.

5 Replies
Not applicable

How to add new Total COLUMN in Pivot Table?

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

- Sridhar

Sokkorn
Honored Contributor

How to add new Total COLUMN in Pivot Table?

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

How to add new Total COLUMN in Pivot Table?

Hi,

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

Thanks,

Ruby

Not applicable

How to add new Total COLUMN in Pivot Table?

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

How to add new Total COLUMN in Pivot Table?

Thanks Richard. Its working......

Community Browser