Cross-Tab Groups by Date Not Working
I am using a cross-tab to display the number of phone calls and emails are team made in a given period. I named three groups under each activity to count the number per Week To Date, Month To Date and Year To Date...
As you can see from my screenshot, year to date does not display. The grouping is a simple sum formula for counting any activities with dates that are in the period YTD.
I have a feeling it has to do with data belonging to more than one group. In other words, an activity counted as "Week to date" would also belong to "Month to date" and also "Year to date", but it can only belong to one group. Is that true? Is there a way to resolve this.
It seems like a simple cross tab report that I should be able to do.
Thanks in advance for any help!