Hi, in the attached you will see that I have a sample pivot table with revenue, gross profit and GP%. My issues is with the totals for the GP% columns. It is summing the values. Is there a way to change this to do a weighted average GP by Company?
Thank you for the help.
Bookmarks