Calculating group average in Pivot table

B

Borge

Hi,
I have collected some data for a lot of sections in a road network, and I am
using a pivot table for a simple analysis.
In this analysis each section is grouped together in two hierarcic levels
road and district. so that each district contains several roads, and each
road contains several sections.

One of the attributes are summarised for all sections in a road, and for
each district I want to compute the average of all roads. My problem is that
the Pivot table only seems to compute the average of all sections in each
district. (that is N=number of sections and not number of links)

Any help is appreciated...


Regards
Boerge *<|:)
 
Top