cgrady2020
New Member
- Joined
- Oct 28, 2008
- Messages
- 36
Hi there,
I'm not sure if this problem even has a solution. It may not be possible.
I want to use a pivot table to show the weighted average of two columns but for it to change dynamically according to how it is filtered. The only way I can think of doing this is to have a column that will add up to the weighted average but this may not be possible. I have attached a screenshot showing how I think this would work.
Or does anyone know of another way of doing this?
Any help would be much appreciated.
Thank you.
Screenshot:
http://www.imageupload.org/?d=74BDFB0F1
I'm not sure if this problem even has a solution. It may not be possible.
I want to use a pivot table to show the weighted average of two columns but for it to change dynamically according to how it is filtered. The only way I can think of doing this is to have a column that will add up to the weighted average but this may not be possible. I have attached a screenshot showing how I think this would work.
Or does anyone know of another way of doing this?
Any help would be much appreciated.
Thank you.
Screenshot:
http://www.imageupload.org/?d=74BDFB0F1