Count Last Occurrences

[vinicius_siquei]

Folks,

I'm trying to create a expression to count active customers. I need to present:

• Customers who bought in the current (or Selected) month
• Customers which the last purchase was on past month (or month previous to the selection)
• Customers which the last purchase was on 2 months ago (or 2 previous to the selection)

My difficulties is related to identifying when was the last purchase dynamically, and the count.

Could anyone help me ?

Thx,

Vinicius

[MarcoWedel]

can you please provide sample data?

thanks

regards

Marco

[maxgro]

hope to understand,

see attachment

[vinicius_siquei]

The example, really helps.

But If I understood it rightly, I still miss something.

For instance, the customers I count for last month must not have any purchase in this month.

I have to count the customers which had they last purchase in the period. If I'm counting customers with last purchase 2 months ago, I cannot consider customers who bought on past and current month.

Am I being clear on the idea ?

Could you please help me ?