We leverage a concatenate field to be able to indicate when milestones fall during certain weeks. We are wondering if there is a way to revise the formula so that we can have the grouping be in order chronologically by year. I have supplied the formula that we have and how the grouping is appearing today below.
I think you're going to need to make the formula lead with the date and the year specifically I'm afraid
As a workaround, perhaps you could just filter out laste year's data? Or maybe group by the year first?
Thank you! Switching the year to the front made all the difference.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.