AGGR COUNT MONTHS WHERE A PRODUCT WERE BUY FOR A CLIENT

[#1]

Hi,

I would like to know if there is posible to With this table

Sells:
MonthYear,
Client,
Product

to create an expression that COUNT de quantity of clients that buy a product in the diferents 12 months of the year.
The table only have the dimenson of the product.

Then, I will have to do the same but for those clients that only  buy the produc in 11 months of the year.. and one expresion for the 10 months and one expression for the 9  etc...

At least the user will be able to select the 12 months  stanting in the monthYear he prefer.

Please, help me, I do not know how to do this !!

[danieloberbilli]

Thanks Rodrigo - but maybe you should rather mark Jagan's last post as correct as I was just adding something to his idea.

Thanks anyway

Kind Regards

Daniel

[#3]

You are right Daniel !

Thanks for been so correct person, it is nice to work with this kind of people !

Thanks a lot again !