There is this report, but I guess it kind of works in reverse of what you’re asking for, @jaeson.paul.
I can envision a set of operations that would get you this data.
- In a new sheet, specify a category and a date range (just to manage the scope of what is queried… for performance).
- Use a QUERY or FILTER function to get all transactions within that date range with the selected category.
- Use the SPLIT function on all contents of the Tags column to individualize the tags. (I haven’t tried this but you’d need to create a single concatenated string from the range… and there may be an issue with the string size overflowing).
- Run a UNIQUE function against that data to reduce the tags to a list of distinct (non repeating) tags.
- Run a SUMIF function to query for each unique tag.
That’s how I’d work up to it.
Hope this flow helps.