millhouse123
Active Member
- Joined
- Aug 22, 2006
- Messages
- 335
I have a data from a single table that I am pivoting and I need to calculate a weighted average. I have looked all over for documents on this topic but have not found exactly what I am looking for. What I need to do is regardless of the selection in the filter I need to take the value of the book value in the current row and divide it by the total book value of all records that are showing in the pivot table.
example:
Book Value Result
1. 1000 10%
2. 2000 20%
3. 7000 70%
I figure this should be pretty easy but I have yet to be able to figure it out.
Thanks so much for your help.
example:
Book Value Result
1. 1000 10%
2. 2000 20%
3. 7000 70%
I figure this should be pretty easy but I have yet to be able to figure it out.
Thanks so much for your help.
Last edited: