count the transactions against each admin and avg transaction per admin

[deeavhad]

Hi

I have data like this

Admin	Transactions
A	T1
B	T2
C	T3
D	T4
A	T5
D	T6
B	T7
C	T8
D	T9
C	T10
A	T11
B	T12
B	T13
A	T14
A	T15
A	T16
B	T17
B	T18

on this data I made a pivot like below

Row Labels          Count of Transactions

A	6
B	6
C	3
D	3

Now I want avg of transaction per admin, how to do that using expression

[MayilVahanan]

Hi

Do you want like this?

[MarcoWedel]

=Avg(Aggr(Count(Transactions),Admin))

hope this helps

Marco