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: | 490 |
Nodes: | 16 (1 / 15) |
Uptime: | 74:26:49 |
Calls: | 9,678 |
Calls today: | 2 |
Files: | 13,722 |
Messages: | 6,172,511 |