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 (2 / 14) |
Uptime: | 146:38:13 |
Calls: | 9,694 |
Calls today: | 4 |
Files: | 13,731 |
Messages: | 6,178,588 |