5 Replies Latest reply: Aug 21, 2014 3:30 PM by Chanel Choo RSS

    Sales Improvement % by date

      Dear Community,

       

      I would like to write an expression to get % improvement in Sales by date comparison, but my expression seems like not working.

      sum({$<Day = {$(=Only(Day))}>}Sales)-sum({$<Day = {$(=Only(Day)-1)}>}Sales)

      Anyone could help?

      I have attached the qvw file, table in excel sheet is the table that is needed to show on dashboard.

       

      Thanks,

      Chanel