I'm looking for the same solution. I can do the
calculation externally to the Pivot Table but would like
to do it internally so that data can be refreshed.
-----Original Message-----
I have a table about the quantities ordered and the
quality received with the following fields: country,
material, product group
Now I want a pivot table with the weighted average of the
quality:
sum(quality*quantity)/sum(quantity)
Pivot-tables don't offer weighted average.
In my example I always get medium quality 2, no matterhow
many high quality items I got.
How can I get the real picture?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 491 |
Nodes: | 16 (3 / 13) |
Uptime: | 136:39:16 |
Calls: | 9,693 |
Calls today: | 3 |
Files: | 13,728 |
Messages: | 6,177,929 |