Filter by Customer Segment

Hi everyone,

I would like to calculate 

Q1. total count of visit;

Q2. total spend 

for each user on the last 3 months, last 6 months and last 9 months.

Filter created:

3 filters are required as per user requested.

Formula applied for time period:

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:

When user selected Time Period = "Last 3 Months" and Frequency = "2 to 4 times"

When user further filter by selected Amount = "RM100 and below"

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

Any help would be much appreciated.

Thanks in advance!

Kindly Regards,

Milan