I've been reading everything I can and haven't figured out the answer.
If I do something like... "Sum(Filter(SharePoint List, FiscalYear = 2022 && ItemName = "Chocolate"), Cost)" I get a delegation warning because Sum is not delegatable. I totally get that, however, I know my filter will never result in more than 12 possible records. There could be a million rows of data in the SharePoint list, but no item is ordered more than 1x each month and I only want 1 years worth of orders for 1 product and therefor, I will only ever have a maximum of 12 records being summed.
In this scenario, can I ignore the delegation warning? Or is there some other way around it that would result in 1st getting my max 12 records and then summing them?
