Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've the below table.
Year | YearMonth | Market | Sales |
2024 | 2024-Jan | IND | 100 |
2024 | 2024-Feb | ANZ | 200 |
2024 | 2024-Mar | NAM | 300 |
2023 | 2023-Jan | IND | 150 |
2023 | 2023-Feb | ANZ | 250 |
2023 | 2023-Mar | NAM | 350 |
2022 | 2022-Jan | IND | 160 |
2022 | 2022-Feb | ANZ | 260 |
2022 | 2022-Mar | NAM | 360 |
my requirement if user selects 2024 from Year filter and 2024-Jan and 2024-Feb from YearMonth is has to show 2024 Year and 2023 Previous Year Sales. Below is what I'm expecting.
Year | 2024 Year Sales | 2023 Year Sales |
2024 | 300 | 400 |
if user selects 2023 from Year filter and 2023-Jan and 2023-Feb from YearMonth is has to show 2023 Year and 2022 Previous Year Sales. Below is what I'm expecting.
Year | 2023 Year Sales | 2022 Year Sales |
2023 | 400 | 420 |
Create month number field in back end script then
Current Year YTD:
Sum({<Year={$(=max(Year))},MonthNum={'<=$(=max({<Year=$(=max(Year))}>}MonthNum))'}>}Sales)
Previous Year YTD:
Sum({<Year=,Year={$(=max(Year)-1)},MonthNum={'<=$(=max({<Year=$(=max(Year))}>}MonthNum))'}>}Sales
without adding MonthNum in the backend, can't we directly do in the front end set analysis?