5 Replies Latest reply on Dec 7, 2012 2:59 PM by Maqs-Oracle

    Previous Month Customer Count

      Hi all,

      I hope you can help me with my little problem.

      I am using BI version and would like to create a report, where there are going to be two columns (along with a number of others):

      1. Number of customers for the selected month (using a dashboard prompt)
      2. Number of customers for the month before the one selected above

      It is easy to create #1 with COUNT(DISTINCT "Dim Sender Customer V"."Sender Customer Id"). I'm not sure how I can create #2... any ideas?