Typically my reports and dashboards need at least two levels of granularity (more than simply aggregate totals), but I’m finding myself in need of exactly that.
I’ve been tasked with creating an executive report comparing profit over various time frames. I don’t need to see that profit broken out by any deeper data segments for this report, just high level analysis over various periods.
The modes available for ‘Sales Summary’ don’t appear to meet my need to be able to display aggregate totals over different slices of time in the same query, and while I know exactly how to get what I want in Custom Mode, I can’t seem to get Custom Mode to work with Sales Summary.
Any help or suggestions would be appreciated, thanks!