5 Replies Latest reply: Dec 7, 2012 8:59 AM by Maqs-Oracle RSS

    Previous Month Customer Count

    969883
      Hi all,

      I hope you can help me with my little problem.

      I am using BI version 11.1.1.6.5 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?

      Regards,

      Cihan