3 Replies Latest reply: Mar 21, 2012 10:51 AM by Marc Wintjen RSS

    Pivot Table Madness - Calculating Weighted Avg

    Marc Wintjen

      Hi - I'm in Pivot Table Madness right now.  I'm trying to calculate a Weighted Avg by multipling two differnent % of Total Calculations.  I can come up with the correct numbers but having issues displaying it as a Pivot or Straight Table because I don't want to show one of the dimensions that is used in the calcuation.  I've attached an example - any assistance would be greatly appreciated!