Hi - I’m trying to track spending for various entities by date, to allow the creation of a chart of spending by month.
Our database has a list of Advertisers. And each of those Advertisers is linked to many Advertisements. Each Advertisement has already been assigned a dollar value and each record also has a date.
How would I create a chart for each advertiser for what they’ve spent in a given date range — ideally by month and/or quarter?
I’ve been able to create a cumulative sum of ad spending per Advertiser, but I’m stumped on breaking it down by month.
Any help much appreciated! Thanks!