Pivot table - partial sum

[#1]

Hello.

I have constructed a pivot table and have set up a partial sum to calculate my total column

My expression is an average of my headcount. However, for my TOTAL column also works the average out.

So in the example below, instead of having 8.77 as a total, I want 16.50 + 49.4 + 2.10 + 8.00 + 3.00 = 79

How can I acheive this?

Many thanks

[#2]

Hey,

So when I apply the same expression, it makes no difference in my application

I am encasing it within another IF statement:

IF(PLLineSort='HEADCOUNT (FTE)',

IF(Dimensionality() <> '1', 

num(sum({< TransactionType = {'PL'}, Type={'Actual'}, CAT={'Heads'}, MN_Num = {">=$(vReportingYearStart)<=$(vReportingDate)"} >}[Value EUR]), 0.00),

num(avg({< TransactionType = {'PL'}, Type={'Actual'}, CAT={'Heads'}, MN_Num = {">=$(vReportingYearStart)<=$(vReportingDate)"} >}[Value EUR]), 0.00)),

It still gives me the average at the total level