This discussion is archived
5 Replies Latest reply: Dec 7, 2012 6:59 AM by Maqsood Hussain RSS

Previous Month Customer Count

969883 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points