Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a straigt table chart with dimension district and as expresssion
=avg(aggr(count(id),district,publication))
Hope this helps,
Stefan
Create a straigt table chart with dimension district and as expresssion
=avg(aggr(count(id),district,publication))
Hope this helps,
Stefan