On Saturday, July 21, 2001 at 12:16:33 PM UTC+3, Richard Withey wrote:
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 matter
how
many high quality items I got.
How can I get the real picture?
Hello All,
It's 20 years,
Did anyone know how to do this?
I wanna calculate weighted average through pivot tables,
is there is any solution to do it automated through pivot tables now, or should I calculate it manually same as 20 years ago.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)