Zero and almost zero customers

Hello,
Client is asking to create a customer analysis where he can see what are his zero and almost zero clients.
Definition:
Zero: haven't bought anything in the last year
Almost zero: bought something in the last 12 month but not in the last 6 months

Someone a good idea to get this build into the sales cube ?

Thanks in advance, have a nice day,

Ronny