Store Type Analysis

Hello patroriki,

Can you please try:

1. Create Calculated Columns:

FY Year = RELATED('Table2 Calendar'[FY Year])
Month = RELATED('Table2 Calendar'[Month])

2. Create Additional Calculated Columns

MaturityBucketName =
SWITCH(
   TRUE(),
   [TimeToMaturity] < 2.25, "Under 2.25 years to maturity",
   [TimeToMaturity] >= 2.25 && [TimeToMaturity] < 3.25, "Between 2.25 and 3.25 years to maturity",
   [TimeToMaturity] >= 3.25, "Above 3.25 years to maturity"
)

MaturityBucketID =
SWITCH(
   TRUE(),
   [TimeToMaturity] < 2.25, 1,
   [TimeToMaturity] >= 2.25 && [TimeToMaturity] < 3.25, 2,
   [TimeToMaturity] >= 3.25, 3
)
​

3. Create a Pivot Table Visualization

• Rows: "Filter 1", "Filter 2"
• Values: "Total Store Count", "Total Value", "Repeat Store Count", "Repeat Store Value", "Lapser Store Count", "Lapser Store Value", "New Store Count", "New Store Value"

Should you require further details or information, please do not hesitate to reach out to me.

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.