5 Replies Latest reply: Sep 18, 2013 5:34 AM by Vishwaranjan Kumar

# average of Pivot partial sums

Hey!

I'm new in qlikview and my english is not really good - so, first of all: sorry!

My problem is the following:

I have different departments with different number of employees.

Now i want to have in the column "Total" the average of all month and not the total number.

I'm using a Pivot table in qlikview!

DepartmentJanFebMarAprMayTotal
A5238321
B2142312
C3181114
Total1041511747

Does anybody know what to do?

Thanks and best regards!

• ###### Re: average of Pivot partial sums

You can use the dimensionality() function in an if statement to calculate a different expression for the detail cells and the total cells. See attached example.

• ###### Re: average of Pivot partial sums

Hi G Wassenaar,

Your attachement is 92342 not 92318. I don't see the Dimensionality() function.

• ###### Re: average of Pivot partial sums

Hi!

I use an if statement in the expression; "dimensionality()=0" for the "vertical" total,  "ColumnNo()=0" for "horizontal" totals.

example:

if(ColumnNo()<>0, MyExpression, TotalExpr)

• ###### Re: average of Pivot partial sums

i think you drag the month column in pivot if yes then

in total column write this

sum(field)/sum(total field)in number tab fixed to 2 and check on show in %

• ###### Re: average of Pivot partial sums

hi

firstly for find the average--

write syntax-

sum(fieldname)/sum(total fieldname)

***************************************

in presentation tab

select field and check show partial sum.