By using this website, you agree to our Terms of Use (click here)
I am building a report where I need to group the data first by Quarter then by a group of salesmen.ย I don't have a field within Acumatica that defines the group of salesmen however I know who is supposed to be in which group.ย Has anyone had success in doing this with an expression in the grouping settings?ย I have successfully grouped by the month using the Month (date) function but I can't find anything that will work for the quarter.
Try joining to the DateInfo table 😀ย
