Weekly spending (analysis) by group - not category

Hi - sorry if this has been asked. I thought it would have but can’t find it on my searches.

Is it possible to analyse weekly spending but by Group, not category. I can see monthly group spending trends by month, but weekly is what I really need to fine tune our spending and stay on top of it each week.

Thanks in advance
Dean :smile:

Hi @deanowilliams47, the best solution to this is probably a pivot table that has groups for the rows (instead of category) and week for the columns (instead of month). The Transactions sheet has the week column already by default in it, but you’d need to add the Group column. Here is a help article that explores how to create spending table by group and how to add the group column to your Transactions sheet.

1 Like