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.
