cancel
Showing results for 
Search instead for 
Did you mean: 

Count to calculate the number of different stores the last 5 purchases

former_member231940
Discoverer
0 Kudos

Hi Gurus,

Good Morning,

We have a requirement to find

The number of different stores the customer have done the last 5 purchases.

We have created a query on top of Infocube and the query design as follows:

ROW

Customer

Plant

Calender day

Column


zcount (If the customer is visiting in the same store it should not count again)

we tried with BADI to populate data row wise, but we are unable to do that.

Please suggest us, if any other procedure to populate the count during the run time.

Appreciate if you could help us.

Thanks

Abhinav.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182470
Active Contributor
0 Kudos

Hi,

1) You need to create a Count CKF and put 1 in your formula area and use Standard Aggregation

2) Create a CKF for Customer Count and put Count CKF(of Step 1) with exception Aggregation-->Counter of all detailed Values-reference char as Customer

With above steps you have created Customer Count of unique. It doesn't consider repeated visits.

3) Now create a RKF with Customer Count CKF and exclude Customer Code as Not assigned.

Finally you can use this RKF in your report.

Regards,

Suman

anshu_lilhori
Active Contributor
0 Kudos

HI,

Can you explain all this with sample data.

Regards,

Al