# Automatically record a total

**URL:** <https://forums.knack.com/t/automatically-record-a-total/10192>\
**Category:** Get Answers\
**Created:** [March 7, 2016, 12:11pm UTC](https://forums.knack.com/t/automatically-record-a-total/10192 "2016-03-07T12:11:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![LaraSchoen37547](https://avatars.discourse-cdn.com/v4/letter/l/5f9b8f/32.png) [@LaraSchoen37547](https://forums.knack.com/u/LaraSchoen37547)\
**Post date:** [March 7, 2016, 12:11pm UTC](https://forums.knack.com/t/automatically-record-a-total/10192/1 "2016-03-07T12:11:36Z")

</div>

I have a number of different "groups" each with prospects, clients and ex-clients connected to them. &nbsp;I would like to track the fluctuation in group numbers on a weekly basis. &nbsp;Knack can currently give me the totals in each group, as well as the grand total, but only as things stand presently.&nbsp;

How do I get Knack to automatically record the totals at the end of say every week into a new table so I am able to "look back into the past" and see the number fluctuations over the last year for example?

---

<div class="post-metadata">

**Author:** ![Anne-Marie52953](https://avatars.discourse-cdn.com/v4/letter/a/7ba0ec/32.png) [@Anne-Marie52953](https://forums.knack.com/u/Anne-Marie52953)\
**Post date:** [October 25, 2017, 1:53pm UTC](https://forums.knack.com/t/automatically-record-a-total/10192/2 "2017-10-25T13:53:03Z")

</div>

That's what I would like to do - have you been able to achieve it yet?

&nbsp;