Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to write a set analysis for Max Year and Max Calendar Week.
Year | Week | Sales |
2022 | 1 | 1001 |
2022 | 30 | 3003 |
2022 | 52 | 5252 |
2023 | 1 | 1234 |
2023 | 2 | 2345 |
2023 | 3 | 3456 |
=Sum({$<Year= {$(=Max(Year))}, Week= {$(=Max(Week))}>} Sales)
Given above expressions returns me year = 2023 year while week = 52 week.
Infact, it should be year = 2023 and week = 3
Thanks
Hello 007,
You need to specify explicitly that you need max. week for the max. year.
Sum({$<Year= {$(=Max(Year))}, Week= {$(=Max({<Year={$(=Max(Year))})>} Week))}>} Sales)
I hope it solves your issue.
Hello 007,
You need to specify explicitly that you need max. week for the max. year.
Sum({$<Year= {$(=Max(Year))}, Week= {$(=Max({<Year={$(=Max(Year))})>} Week))}>} Sales)
I hope it solves your issue.