# Rollup sheet with transaction list **URL:** \ **Category:** Google Sheets\ **Created:** [December 13, 2024, 5:39pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382 "2024-12-13T17:39:20Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mk1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mk1/32/15871_2.png) [@mk1](https://community.tiller.com/u/mk1)\ **Post date:** [December 13, 2024, 5:39pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382/1 "2024-12-13T17:39:20Z")
đź‘‹ I would like to have a sheet that does the following: - shows a pie chart based on categories (similar to Category Tracker) - allows for selecting a category, which then would show a list of all individual transactions for that category (similar to Transaction Tracker) - filtering based on time and account This is basically a combination of Category tracker and Transaction tracker. I want to see a high-level spending breakdown for a specific account, and then easily see individual transactions (the why) for a specific category. Does something like that already exist? ---
**Author:** ![brettanicus](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brettanicus/32/9057_2.png) [@brettanicus](https://community.tiller.com/u/brettanicus)\ **Post date:** [December 13, 2024, 11:22pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382/2 "2024-12-13T23:22:28Z")
@rhowell; I noticed in your shared spreadsheet for the Scheduled Transactions template that you have a “Category Tracker +” sheet. Is that a modification that you created, and do you plan on sharing it? I’ve found it very useful and it sounds like what Martin is looking for. ---
**Author:** ![rhowell](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/rhowell/32/12900_2.png) [@rhowell](https://community.tiller.com/u/rhowell)\ **Post date:** [December 19, 2024, 3:49pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382/3 "2024-12-19T15:49:35Z")
> [@brettanicus](#): > > I noticed in your shared spreadsheet for the Scheduled Transactions template that you have a “Category Tracker +” sheet I do – never got around to writing up any documentation but happy to share it. @mk1 You can copy the **Category Tracker+** tab from my shared sheet and see if it works for you. It’s just the Category Tracker from Community Solutions with a couple additions I found useful. I think it addresses all your requests except for filtering by account. I might be able to add that if you’d find it helpful. Let me know. > **[SHARED Tiller Foundation Template](https://docs.google.com/spreadsheets/d/1dHwvO0RibgFwhZ-7Xn64yzgfpj0RGHSyQeXBHYVGiBo/edit?usp=drive_link)** > > This Sheet is private ---
**Author:** ![mk1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mk1/32/15871_2.png) [@mk1](https://community.tiller.com/u/mk1)\ **Post date:** [January 16, 2025, 3:50pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382/4 "2025-01-16T15:50:26Z")
Thank you for your reply. I think the main thing I am looking for is the ability to do more filtering on the whole chart (and have the same filter applied to the individual transactions). I like the flexibility of the Transaction Tracker for filtering on anything. With that said, I primarily need the ability to filter by account. The Category Tracker+ is great! I like the addition of the bar chart, and the filtering of transactions by tags is useful as well. Thank you for sharing this. ---
**Author:** ![brettanicus](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brettanicus/32/9057_2.png) [@brettanicus](https://community.tiller.com/u/brettanicus)\ **Post date:** [January 17, 2025, 4:41pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382/5 "2025-01-17T16:41:20Z")
I added a pie chart to my version of the Transaction Tracker. It displays the values returned in the aggregated area to the right, with the pie slices by whatever value you selected in the Group By dropdown, which can be Categories. That way you can filter the results however you like, and it’ll match the detailed transactions returned by Transaction Tracker. ![Transaction Tracker Pie Chart](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/1/c/1c6c96183f4d74dc1ad4b25d0d1035e686ab227c.png) ---
**Author:** ![mk1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mk1/32/15871_2.png) [@mk1](https://community.tiller.com/u/mk1)\ **Post date:** [January 18, 2025, 10:20pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382/6 "2025-01-18T22:20:32Z")
@brettanicus Thank you! Where can I access your version of the Transaction Tracker sheet? ---
**Author:** ![brettanicus](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/brettanicus/32/9057_2.png) [@brettanicus](https://community.tiller.com/u/brettanicus)\ **Post date:** [January 18, 2025, 11:30pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382/7 "2025-01-18T23:30:08Z")
You can copy the sheet from this link: > **[Transaction Tracker+ with Pie Chart](https://docs.google.com/spreadsheets/d/1T60Dxuf1FG5e_tGkpYR6KOuupvszxARzhSgUQ9XOYbE/edit?usp=drive_link)** > > This Sheet is private _(right-click tab, choose Copy To \> Existing Spreadsheet, then choose your primary Tiller file)_ Note the ± sign that groups rows 1-12. That’s useful once you’ve set your filters so you can fold that section to get more screen space. ---
**Author:** ![mk1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mk1/32/15871_2.png) [@mk1](https://community.tiller.com/u/mk1)\ **Post date:** [January 18, 2025, 11:53pm UTC](https://community.tiller.com/t/rollup-sheet-with-transaction-list/29382/8 "2025-01-18T23:53:39Z")
This is perfect, thank you again!