2 Replies Latest reply on Oct 30, 2018 9:24 AM by craig Webb

    Comparing 2 different time frames

    craig Webb

      Hello,

       

      Is it possible to compare 2 different time frames?

       

      I have a flat data file that consists of Week_No, Store_No, Sales_TY, and Sales_LY. I can create YoY Sales no problem because if my structure. What i would like to do though is to be able to compare YoY AVG wkly sales for lets say Week_No 1-5 and YoY AVG wkly sales for Week_No 6-12 because  a new competitor opened up shop in week 6.

       

      In the TEST file i attached, i created 2 work sheets one called YoY Pre, and YoY Post. I Then through them on a dashboard right quick. What i would like to do is for a used to be able to select the weeks they want in the YoY Pre Table, then select the weeks they want in the YoY post table, and have another KPI that Subtracts the AVG WKLY YOY in the Pre table from the AVG Wkly YOY in the POST table.

       

      Any suggestions?