Here is the Case:
Customer participated in Sales events and make purchase. The management want a report to show how each event, each customer is doing compare to the last time.
In the load script I will generate "prev_Event_Date" And "prev_Event_ID" for each of the purchase. So the report for customer level is easy to do....The problem comes when I try to generate the report on event level. In general, I need to show the number of customer comparing selected and previous run. I create a report which have 2 dimension Event Id and Event Type, I use = Max(Pre_Event_Date) as Last event Date, and base on the Last event Date I can find the Last event ID. but I cannot count the number for customer in the Last event because the Event Id is in the dimension.
Anyone have any idea how we can Ignore the dimension and count({<Event_ID = Pre_Event_ID >} Distinct Customer ID)??
