3 Replies Latest reply on Sep 7, 2018 10:01 AM by Yidou Li

    How to create dynamic YOY % chg by comparing two different measures

    Yidou Li

      Hi everyone,

       

      I'm trying to create a dynamic YOY % chg of our sales forecast vs. the actual sales a year ago by month. And there's also two filters of product and family applied.

      The source data looks like this and it goes on to August 2018. I'm trying to create a dynamic YOY % chg that calculates the forecast $ of table in July-18 vs. the actual sales of table in July-17 to see what % increase the forecast is whenever users select a filter on a certain product. How can I create the calculation? Created one like this "[Forecast $]/[Actual $ Sales]-1" but it didn't work.

      Thanks!

        

      DateFiscal YearProductFamilyActual $ SalesForecast $
      Jul-17FY18tableA$33,250$39,900
      Jul-17FY18paperA$3,814$4,577
      Jul-17FY18penB$29,375$35,250
      Jul-17FY18pinB$18,374$22,049
      Jul-17FY18chairC$38,271$45,925
      Aug-17FY18tableA$3,288$3,946
      Aug-17FY18paperA$3,921$4,705