average of Pivot partial sums

[#1]

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!

Department	Jan	Feb	Mar	Apr	May	Total
A	5	2	3	8	3	21
B	2	1	4	2	3	12
C	3	1	8	1	1	14
Total	10	4	15	11	7	47

Does anybody know what to do?

Thanks and best regards!

[Gysbert_Wassenaar · Accepted solution]

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.

[#3]

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)

[#4]

Hi G Wassenaar,

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

[er_mohit]

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 %

[#6]

hi

firstly for find the average--

write syntax-

sum(fieldname)/sum(total fieldname)

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

in presentation tab

select field and check show partial sum.