13 Replies Latest reply on Apr 16, 2018 2:19 AM by Rajeev Pandey

    WorkoutWednesday 13 - Facing problems with LOD

    Rajeev Pandey

      Hi Team,

       

      I was trying to solve the WW 13 but I am struck when I am calculating Average Sales per order. It working fine for the white portion but it's not working for other cells.

      I know this can be easily done when we duplicate the database but I haven't duplicate the database and used the techniques which (Alexander Mou) taught us via densification.

       

      WW link : Week 14: Frequency Matrix – Workout Wednesday

       

       

      WW Requirements:

       

      I have created multiple formulas for testing the average Sales per order but it's not working at all.

       

      When I am using this formula, I am ending up with like this.

      Average sales per order should appear for each combination(Cell). I  tried a lot but don't know what I am missing here.

       

      Attaching the workbook for your reference.Please refer the last sheet (ww13)

       

       

       

      Alexander Mou

      Simon Runc