2 Replies Latest reply on Aug 3, 2018 8:14 AM by Ed Yeldham

    Volume and Price Calculations and Level of Detail

    Ed Yeldham

      Hello,

       

      I have managed to create working volume and price variance calculations as shown in the attached workbook with superstore data which replicates my live data.

       

      My question is that having proven my calcs work at a customer and product level as shown in the "Detail" tab when I then summarise to a higher level of detail e.g segment on the "Summary" tab the split of the variance changes.

       

      I'm assuming this is to do with level of detail as it is calculating at the data level it sees not the underlying data.

       

      Whilst it might be mathematically correct it will confuse my end users as they will see one set of numbers then drill to detail which is different.

       

      How do I resolve and have others had similar experiences and how did they resolve?

       

      Help appreciated.


      Ed