AVG count function

Mon, 20 Aug 2012 08:32:28 GMT

Hi experts,

I have a problem with my pivot table. I will explain the problem.

I have a table that looks like this

id publication reaction district

1 2012_1 1 Holland

2 2012_1 2 Holland

3 2012_1 3 Holland

4 2012_1 4 Germany

5 2012_2 1 Holland

6 2012_2 2 Germany

If I make a count on district the result will be like Holland 4 and Germany 2

The situation i want is that there will be a count per publication on district.

The result i want is:

Holland = 2 publication 2012_1 = 3 + publication 2012_2 = 1 3 + 1 = 4 Average = 2

Germany=1

Can anybody help me?

Thnx

Re: AVG count function

swuehl — Mon, 20 Aug 2012 08:39:11 GMT

Create a straigt table chart with dimension district and as expresssion

=avg(aggr(count(id),district,publication))

Hope this helps,

Stefan