Can someone explain how this breaks down in terms of fields i need to refer to. I've tried a bunch of variations and keep getting #error. I want to sum a column across the Month to date called "SLOutAdj" based on the values in a column called "queue".
I created another table called calender with the dates listed and month number, month name etc. The 'Call' table which contains the SLOutAdj column also contains multiple dates for each day linked to queue names.
I tried this
=TOTALMTD(sum([SLOutAdj],Calender[Date])) but no joy