Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
oboute
Contributor III
Contributor III

Sum columns pivot table

Hello

I have a pivot table with hours of work by employee and by type of hour (project, workorder ...)

Pb sum pivot table 1.png

So I have

  • In dimensions :
    • employee name
    • type of hours
  • In expression :
    • Sum(Quantity)
  • In presentation tab :
    • show partial sums

I would like a last column with total, for example here 42,20 + 430 + ... + 542,60 = 17145,8

When i try to add an expression with Sum(Total Quantity), the column is displaying for each type of hours :

Pb sum pivot table 2.png

How to do to have only one column at the end ?

Thanks in advance

1 Solution

Accepted Solutions
marcus_sommer

The partial sums will be enabled on the dimensions and not on the expression and will by default use for the total the same expression - I think you should simply try it.

- Marcus

View solution in original post

7 Replies
marcus_sommer

Within the presentation (top left) you could enable partial sums for each dimension separately.

- Marcus

Anil_Babu_Samineni

Can i know, Where do you fetch from the Raw Data ?

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
oboute
Contributor III
Contributor III
Author

Hello,

I can't, it's in grey for my totals :

Pb sum pivot table 3.png

PrashantSangle

Hi,

Presentation > select dimension > check show partial sum.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
oboute
Contributor III
Contributor III
Author

Hello, as well as i answer to Marcus, it's in grey i can't check...

marcus_sommer

The partial sums will be enabled on the dimensions and not on the expression and will by default use for the total the same expression - I think you should simply try it.

- Marcus

oboute
Contributor III
Contributor III
Author

It's Ok thank you !!!

I checked partial sum on the dimension, on the presentation tab :

Pb sum pivot table 4.png