0 Replies Latest reply on May 21, 2013 2:38 AM by Elad Lanir

    Week over Week how to

    Elad Lanir

      Hi,

       

      I'm trying to do a WoW comparison, without displaying the time dimension in the view.

       

      I want the data to look something like:

      RegionCurrent week SalesPrevious week salesCurrent week profitPrevious week profit
      Current week % profitPrevious week % profit
      Change in % profit
      North100090080070080%87.5%-7.5%
      South200015001300100065%66.66%-1.66%
      Center300027001500100050%37%13%








       

      Notice that the column 'Change in % profit' is a simple delta and not a % change.

      In addition, I would like to have a filter that will default to current but the user, if wishes, will be able to choose previous weeks.

       

      Couldn't find anything similar in the forum. Some help maybe?