Skip to main content

I have been looking everywhere to see if this is correct or incorrect. Should you really only refer to the dimensions on the left and then use them in the calculation to the right of the colon. I would really appreciate an explanation if possible.

4 respostas
  1. 9 de nov. de 2022, 04:58

    ​ @Bennie Warren​ 

    The format which you given it's not correct.

     

    Fixed segment and shipmode then calculated sales, these dimensions are present in the sheet.

     

    ​ @Bennie Warren​ The format which you given it's not correct. Fixed segment and shipmode then calculated sales, these dimensions are present in the sheet. 

    now you will add one more dimension region to the view but sales got distributed based on new dimension but LOD values are fixed to segment and shipmode.

    lod2 

    now you will add some condition to lod to display sales for only one shipmode.

     

    lod3 

    I have attached the workbook for the same.

     

    hope it will help !