2 Replies Latest reply on Jul 18, 2016 7:06 AM by David Raimist

    Help on Averages

    David Raimist

      So I have data that I am presenting by YEAR, QUARTER, MONTH and totaling the data. This works great as I collapse/expand the columns into YEAR, QTR or MONTH

       

      I have then created a copy of this sheet and would like to present the same as percentages. The only time that they are correct is when the data is expanded to MONTH. As soon as I click to rollup the averages appear to become "averages of averages". I created custom formulas for the percentage sheet, but doesn't seem to handle the roll-up scenario. I have attached the workbook. The relevant tabs are #2 and #3 ('Number' and 'Percentages'). Any assistance is greatly appreciated. The goal is to have the percentages reflect the drill down/rollup.


      David