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

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.