# Category tracker customization - custom column on Transactions

**URL:** <https://community.tiller.com/t/category-tracker-customization-custom-column-on-transactions/28368>\
**Category:** Google Sheets\
**Tags:** tcs-categorytracker\
**Created:** [September 27, 2024, 2:05pm UTC](https://community.tiller.com/t/category-tracker-customization-custom-column-on-transactions/28368 "2024-09-27T14:05:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonathan3](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jonathan3/32/14358_2.png) [@jonathan3](https://community.tiller.com/u/jonathan3)\
**Post date:** [September 27, 2024, 2:05pm UTC](https://community.tiller.com/t/category-tracker-customization-custom-column-on-transactions/28368/1 "2024-09-27T14:05:54Z")

</div>

Hi there,  
Been using Tiller for almost 2 years. Looking now to get better analysis of all my data, specifically in the Category Tracker report.

I’ve added a comment column in transaction tab. I’d love to show my comments per transaction next to the description on the report. I figure this report is grabbing the description row (column C) in the transaction tab. Want to also show ‘Comments’ (tab G) in my transaction tab.

I looked at the formula, have an intermediate knowledge of Sheets, but don’t see a simple change to the formula.

Could use some help from you fine folks!

Many thanks! JW

---

<div class="post-metadata">

**Author:** ![bentyre1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/bentyre1/32/8130_2.png) [@bentyre1](https://community.tiller.com/u/bentyre1)\
**Post date:** [September 27, 2024, 2:13pm UTC](https://community.tiller.com/t/category-tracker-customization-custom-column-on-transactions/28368/2 "2024-09-27T14:13:50Z")

</div>

Yes this is possible you’ll have to adjust the hidden columns over to the right as well to lookup your column that you’re wanting to bring in, and drag down the dynamic references to match.

Then adjust the formula in I12 to bring it in, ive brought in the note column on mine and this is what it looks like

> =iferror(QUERY({INDIRECT(P2),INDIRECT(P3),INDIRECT(P4),INDIRECT(P5),INDIRECT(P10)},“SELECT Col1,Col5, SUM(Col3) WHERE Col4 \>= DATE “”” & text($E$2, “yyyy-mm-dd”) & “”" AND Col4 \<= DATE “”" & text($G$2, “yyyy-mm-dd”) & “”" AND Col2 = “”" & I8 & “”" GROUP BY Col1, Col5 ORDER BY Col1 ASC LABEL SUM(Col3) ‘’, Col1 ‘’", -1))

I believe the additions are the Col5 parts which i also believe would be the same if you brought in your custom column in the hidden section

---

<div class="post-metadata">

**Author:** ![jonathan3](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jonathan3/32/14358_2.png) [@jonathan3](https://community.tiller.com/u/jonathan3)\
**Post date:** [October 2, 2024, 4:05am UTC](https://community.tiller.com/t/category-tracker-customization-custom-column-on-transactions/28368/3 "2024-10-02T04:05:29Z")

</div>

Wow this is great, an easy edit, and works great. Many thanks!!

---

<div class="post-metadata">

**Author:** ![twalane](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/twalane/32/16372_2.png) [@twalane](https://community.tiller.com/u/twalane)\
**Post date:** [October 8, 2024, 9:31pm UTC](https://community.tiller.com/t/category-tracker-customization-custom-column-on-transactions/28368/4 "2024-10-08T21:31:02Z")

</div>

Fantastic! Thanks for your time @bentyre1

---

<div class="post-metadata">

**Author:** ![jonathan3](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jonathan3/32/14358_2.png) [@jonathan3](https://community.tiller.com/u/jonathan3)\
**Post date:** [October 12, 2024, 5:21am UTC](https://community.tiller.com/t/category-tracker-customization-custom-column-on-transactions/28368/5 "2024-10-12T05:21:19Z")

</div>

So the above certainly does work.

Leaving this update in thread for any future users.  
There is also a Detailed Category Tracker tab that somebody created that has all of the above, and more, all ready to go with no scripting changes.

> [@trophy User Request: Detailed Category Tracker](https://community.tiller.com/t/user-request-detailed-category-tracker/6826):
>
> @lillytryon asked this question in another thread: Is there a way that you can create a sheet that allows me to choose a category and see the details of transactions for that category only, for a defined period of time? For example, maybe I want to review the gift category to review transactions during December. Or my Reimbursement category (used for expenses that will be reimbursed–employer, health insurance, etc.) to see what I need to submit for reimbursement for the last quarter. I initi…