Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Pivot Table add row with total

I wish to perform simply the sum of field values for 3 columns of a pivot table chart. should look like this

Portfolio  Rev11  Rev12  Rev13
Port1      10       5         2
Port2      10       10       10
TOTAL    20       15       12

i cannot figure out how to add this TOTAL row. I tried to add SUM(Rev11) in the expression tab, but this is adding a column and not a row. the values in this column are identical to values in the colmn Rev11.

Do you have a link to reference or solution ?

regards

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Pivot Table add row with total

Select Pivot Table

Dimensions...

1)Portfolio

2)Year or RevenueYear

Expression

SUM(Value) or whatever you have

Presentation table...

Select Portfolio and Tick SHOW Partial SUM..

Adjust Year as Column....

View solution in original post

6 Replies
Highlighted

Re: Pivot Table add row with total

Hi

On your Pivot Table Properties go the Presentation tab and tick Show Partial Sums for your first dimension, Portfolio.

Best Regards,     Bill

Highlighted
Not applicable

Re: Pivot Table add row with total

thanks

this is displaying a last row with label total, but no total values are displayed. i get smth like

Portfolio  Rev11  Rev12  Rev13

Port1      10       5         2

Port2      10       10       10

TOTAL  


any idea ?

Highlighted

Re: Pivot Table add row with total

Hi

That is strange, could you share your qvw ?

Best Regards,     Bill

Highlighted
MVP
MVP

Re: Pivot Table add row with total

Please check enclosed file...

Highlighted
Not applicable

Re: Pivot Table add row with total

i cannot read .qvw (Personal edition)

could you briefly explain ?

Regards

Highlighted
MVP
MVP

Re: Pivot Table add row with total

Select Pivot Table

Dimensions...

1)Portfolio

2)Year or RevenueYear

Expression

SUM(Value) or whatever you have

Presentation table...

Select Portfolio and Tick SHOW Partial SUM..

Adjust Year as Column....

View solution in original post