Create a bar or line graph of spending by month/quarter

Topic Labels: Formulas
478 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

0 Replies 0