2 Replies Latest reply on Jun 26, 2019 12:35 AM by sander.binda

    YOY and WOW on same Sub-Category

    Deepti Garg

      Hello all

      I am  showing here WOW Top 5 Area but when i am  going to YOY top 5 its changing the AREA how can i fix the same area as WOW.

       

        • 1. Re: YOY and WOW on same Sub-Category
          Mavis Liu

          Hi Deepti,

           

          Unfortunately this is hard to solve without the workbook.

           

          Please can you provide us with a sample workbook and detail what the issue is?

           

          Thanks,

          Mavis

          • 2. Re: YOY and WOW on same Sub-Category
            sander.binda

            As Mavis said it is quite difficult to help without the workbook but let's try to look at the mechanics.

             

            What you (most likely) did is look for the top 5 WOW and then return the value of that.

            then you looked for the top 5 YOY and return the value of that.

             

            WOW can have a different top 5 than YOY (which in your case happend).

             

            What you want to do is make a calculation that says if the the area is in the top 5 WOW then give me its YOY value.

             

            It is difficult to give you an exact formula without the workbook.