Hello Team,
I have a FiscalMonth and FiscalYear Fields(Fiscal Year starts on October), and i have a data from last 4 years, now i want to create a field to count the number of closed months, please help me on this. Attached requirement.
| Fiscal_Month |
Fiscal_Year |
Last 12 months |
Last 16 Months |
last 24 months |
closed Months |
| 202110 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202111 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202112 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202201 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202202 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202203 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202204 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202205 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202206 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202207 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202208 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202209 |
2022 |
2022 |
2022 |
2022 |
12 |
| 202210 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202211 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202212 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202301 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202302 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202303 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202304 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202305 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202306 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202307 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202308 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202309 |
2023 |
2023 |
2023 |
2023 |
12 |
| 202310 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202311 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202312 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202401 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202402 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202403 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202404 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202405 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202406 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202407 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202408 |
2024 |
2024 |
2024 |
2024 |
11 |
| 202408 |
- |
- |
- |
Last 24 Months |
24 |
| 202407 |
- |
- |
- |
Last 24 Months |
24 |
| 202406 |
- |
- |
- |
Last 24 Months |
24 |
| 202405 |
- |
- |
- |
Last 24 Months |
24 |
| 202404 |
- |
- |
- |
Last 24 Months |
24 |
| 202403 |
- |
- |
- |
Last 24 Months |
24 |
| 202402 |
- |
- |
- |
Last 24 Months |
24 |
| 202401 |
- |
- |
- |
Last 24 Months |
24 |
| 202312 |
- |
- |
- |
Last 24 Months |
24 |
| 202311 |
- |
- |
- |
Last 24 Months |
24 |
| 202310 |
- |
- |
- |
Last 24 Months |
24 |
| 202309 |
- |
- |
- |
Last 24 Months |
24 |
| 202308 |
- |
- |
- |
Last 24 Months |
24 |
| 202307 |
- |
- |
- |
Last 24 Months |
24 |
| 202306 |
- |
- |
- |
Last 24 Months |
24 |
| 202305 |
- |
- |
- |
Last 24 Months |
24 |
| 202304 |
- |
- |
- |
Last 24 Months |
24 |
| 202303 |
- |
- |
- |
Last 24 Months |
24 |
| 202302 |
- |
- |
- |
Last 24 Months |
24 |
| 202301 |
- |
- |
- |
Last 24 Months |
24 |
| 202212 |
- |
- |
- |
Last 24 Months |
24 |
| 202211 |
- |
- |
- |
Last 24 Months |
24 |
| 202210 |
- |
- |
- |
Last 24 Months |
24 |
| 202209 |
- |
- |
- |
Last 24 Months |
24 |
| 202408 |
- |
- |
Last 16 Months |
- |
16 |
| 202407 |
- |
- |
Last 16 Months |
- |
16 |
| 202406 |
- |
- |
Last 16 Months |
- |
16 |
| 202405 |
- |
- |
Last 16 Months |
- |
16 |
| 202404 |
- |
- |
Last 16 Months |
- |
16 |
| 202403 |
- |
- |
Last 16 Months |
- |
16 |
| 202402 |
- |
- |
Last 16 Months |
- |
16 |
| 202401 |
- |
- |
Last 16 Months |
- |
16 |
| 202312 |
- |
- |
Last 16 Months |
- |
16 |
| 202311 |
- |
- |
Last 16 Months |
- |
16 |
| 202310 |
- |
- |
Last 16 Months |
- |
16 |
| 202309 |
- |
- |
Last 16 Months |
- |
16 |
| 202308 |
- |
- |
Last 16 Months |
- |
16 |
| 202307 |
- |
- |
Last 16 Months |
- |
16 |
| 202306 |
- |
- |
Last 16 Months |
- |
16 |
| 202305 |
- |
- |
Last 16 Months |
- |
16 |
| 202408 |
- |
Last 12 Months |
- |
- |
12 |
| 202407 |
- |
Last 12 Months |
- |
- |
12 |
| 202406 |
- |
Last 12 Months |
- |
- |
12 |
| 202405 |
- |
Last 12 Months |
- |
- |
12 |
| 202404 |
- |
Last 12 Months |
- |
- |
12 |
| 202403 |
- |
Last 12 Months |
- |
- |
12 |
| 202402 |
- |
Last 12 Months |
- |
- |
12 |
| 202401 |
- |
Last 12 Months |
- |
- |
12 |
| 202312 |
- |
Last 12 Months |
- |
- |
12 |
| 202311 |
- |
Last 12 Months |
- |
- |
12 |
| 202310 |
- |
Last 12 Months |
- |
- |
12 |
| 202309 |
- |
Last 12 Months |
- |
- |
12 |
