0 Replies Latest reply: Jan 27, 2013 9:44 PM by Bill Ringer Salalima RSS

    How to do expressions for set analysis depends on parameters?

      Hi,

       

      I need help guys, I got problems in creating set analysis for the following:

       

       

      DATE
      ITEM
      AMOUNT
      11/20/2012HTC25555
      11/22/2012SAMSUNG26800
      11/24/2012IPHONE4S35400
      11/30/2012IPHONE4S34758
      12/15/2012SAMSUNG24390
      12/20/2012HTC25525
      12/25/2012IPHONE549899
      12/30/2012HTC25500
      1/2/2013HTC30200
      1/4/2013SAMSUNG28930
      1/5/2013HTC12360
      1/9/2013IPHONE4S34500
      1/20/2013SAMSUNG24333
      1/23/2013IPHONE4S32330

       

      SET ANALYSIS FOR EACH ITEMS (TOTAL SALES)

       

      1) This Year

      2) Last Year

      3) Year-to-date

      4) Last-Year-to-date

      5) This Month

      6) Last Month

       

      Thanks,

      Bill