Forum Discussion
How to weight counts in pivot tables
Since you managed to count the number of Fruit, I'm confident that you can also drag the Weight field into the value area of the pivot table and change its attribute to "Average" rather than "Sum".
Yes, but how do I multiply the average by the count within the pivot table and only show the end value?
I don't follow. Count X Average Weight would be the same as SUM of Weight. You can test it by adding another value field, like:
By the way, I deleted my example that I used in my first response. Therefore you see Name and Value in stead of Fruit and Weight.
Yes, is there anyway to (1) Only show the sum of weight in the pivot table, and (2) write the formula so that it multiplies the weight by the first column, regardless of what the first column is (e.g. I can switch out the fruit column for the color column, or add any additional column without having to create a new calculated field to for every new column)? Riny_van_Eekelen
