Sum columns pivot table

[oboute]

Hello

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

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 :

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

Thanks in advance

[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 ?

[oboute]

Hello,

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

[PrashantSangle]

Hi,

Presentation > select dimension > check show partial sum.

Regards

[oboute]

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

[marcus_sommer · Accepted solution]

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]

It's Ok thank you !!!

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