Customer Segmentation

Hi everyone,

I would like to calculate 

Q1. how many user been visit the store for {2-4 times, 5-7 times, 8 times and above};

Q2. how many user been spend for {RM100 and below, RM101-RM300, RM301 and above};

on the last 3 months, last 6 months and last 9 months.

Variable created:

Last 3 months: EOMONTH(TodayDate, -3)

Last 6 months: EOMONTH(TodayDate, -6)

Last 9 months: EOMONTH(TodayDate, -9)

Date Outcome:

Last 3 months: From 1 December, 2022 until yesterday

Last 6 months: From 1 September, 2022 until yesterday

Last 9 months: From 1 June, 2022 until yesterday

Sample Data:

Expected Outcome:

Does anyone have any ideas what kind of formula I should apply?

Any help would be much appreciated.

Thanks in advance!

Kindly Regards,

Milan