Sum of Avg in Pivot Table

[#1]

Hi,

I am new to Qlikview and have below query.

I have this table data         

Service	Instance	User
A	A1	10
A	A1	20
A	A2	30
B	B2	15
B	B2	10
B	B3	12
C	C1	40

I want to create a pivot table which show expression as [Sum(Avg of Users per instance) per service].

Can someone help ?

[swuehl]

Maybe like this:

Create a pivot table with dimension service and as expression:

=sum( aggr( avg(User), Instance))

[matzenbacher]

someone already answered =b

solve your question?

[angelaecheverri]

If they use Service and Instance as Dimensions....

dont will be better use an expression like

sum(user)/count(user)

or Avg(user)

?

when is better use agg than a simple avg?

when do you use AGG function?