Forum Discussion
How to weight counts in pivot tables
Hi all! I'm so excited to join this community. I was hoping to find some help about an issue I haven't been able to figure out on my own. I have attached a screenshot of a simplified version of t...
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
Not sure I follow. Sorry! Please clarify and/or upload a file that demonstrates what you mean.