Help on partial sum of pivot table

[#1]

Hi,

How can i get the grand total of individual dimension in a pivot table?

Thanks,

Rahul

[#2]

Hi,

In Properties - Presentation tab, below top-left side area, you can see "Show partial sums" tick box.

Select 1st dimension from list above that box and tick in this box.

You should get results you want.

Happy Thoughts

[raghavsurya]

Hi Rahul,

You can achieve this in presentation tab by selecting the show partial sum for the dimension you want.

Regars,

Raghav

[#4]

Hi,

In Properties - Presentation tab, below top-left side area, you can see "Show partial sums" tick box.

Select 1st dimension from list above that box and tick in this box.

You should get results you want.

Happy Thoughts

[#5]

Thank you all,

I've already done this...

I want the total to be 15.7 not 4.49.

[#6]

I've already done this and i want the total to be 15.7 and not 4.49 for unit 'al'

[jonathandienst]

If this were a straight table, you could change the Total Mode to Sum of rows (on the expression tab). In this case, though, you are using a pivot table and I don't tink that will work.

Change the expression to something like this (check closing brackets):

If(Dimensionality()=0,

    Sum(Aggr(Sum(Days)/Count(distinct [EmployeeID]), Event)),

    Sum(Days)/Count(distinct [EmployeeID]))

Dimensionality() will return 0 for the total and 1 for the normal rows (may be 1 and 2 in this case, I am not sure. Try =1 as well).

Regards

Jonathan

[#8]

I've tried but it failed...

The file is attached for your reference.

[jonathandienst]

Hi

Actually did not need to use dimensionality in this case. See attachment which I think does what you need.

The new expression is:

Sum(Aggr(Sum(Days)/Count(distinct [Employee ID]), Event, Unit))

Jonathan