# Perspective Table Footer data

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-footer-data/100867>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [January 14, 2025, 5:28pm UTC](https://forum.inductiveautomation.com/t/perspective-table-footer-data/100867 "2025-01-14T17:28:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Torsten\_Giesbrecht1](https://avatars.discourse-cdn.com/v4/letter/t/f17d59/32.png) [@Torsten\_Giesbrecht1](https://forum.inductiveautomation.com/u/Torsten_Giesbrecht1)\
**Post date:** [January 14, 2025, 5:28pm UTC](https://forum.inductiveautomation.com/t/perspective-table-footer-data/100867/1 "2025-01-14T17:28:10Z")

</div>

How do I get data into the perspective table footer? I'm trying to get the result shown below, taken from the provided link. But I can't figure out where to put the binding.

> [@Problem summing column's values of a table in the footer](https://forum.inductiveautomation.com/t/problem-summing-columns-values-of-a-table-in-the-footer/79832):
>
> Hello gentlemen, I have a problem with a table that I don't know how to solve: I have a table that is populated by a sql query ==\> return format as json: I use this script in order to sum "Quantity" column on the footer (tnx to @[pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)) Here the results: So far so good everything works fine! I wanted to color the background of the rows based on a value. I changed the return format of the query from json to dataSet, (I used a script by @[y…](https://forum.inductiveautomation.com/u/ynejati)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/b/0b0de7c7a6e55fb2b9ef44108ca7a823b5acd432.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [January 14, 2025, 5:59pm UTC](https://forum.inductiveautomation.com/t/perspective-table-footer-data/100867/2 "2025-01-14T17:59:06Z")

</div>

On the table,  
`enableFooterGroups : true`

Then on `footerGroups` create two array elements.  
On the first,  
`footerGroups.0.0.title : record(s)` ← will be modified by binding.  
`footerGroups.0.0.span : 4` ← This field will span the first four columns.  
`footerGroups.0.1.title : total` ← will be modified by binding.

Use the scripts in your linked post and modify to suit.

Tip: when posting screengrabs of bindings it's a big help when it includes the binding editor title bar as this shows the name of the component being edited. It would have helped you!

---

<div class="post-metadata">

**Author:** ![eMax](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@eMax](https://forum.inductiveautomation.com/u/eMax)\
**Post date:** [January 14, 2025, 7:03pm UTC](https://forum.inductiveautomation.com/t/perspective-table-footer-data/100867/3 "2025-01-14T19:03:42Z")

</div>

Hello Torsten,  
here is a screenshot on what I did in order to sum values on footer:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/a/6adaa81cf6d018385e4326f109595ad1c2ecd7fa.png)  
I used an expression structure, one for "normal" values and another one if you filter values (maybe not the best solution but at that time it was the first time I used Ignition). I hope this can help you.

---

<div class="post-metadata">

**Author:** ![Torsten\_Giesbrecht1](https://avatars.discourse-cdn.com/v4/letter/t/f17d59/32.png) [@Torsten\_Giesbrecht1](https://forum.inductiveautomation.com/u/Torsten_Giesbrecht1)\
**Post date:** [January 14, 2025, 7:36pm UTC](https://forum.inductiveautomation.com/t/perspective-table-footer-data/100867/4 "2025-01-14T19:36:47Z")

</div>

Thanks for the quick replies guys! And I agree, including the binding title would have saved me from posting. Here's my test:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/5/9532b22b04f8ab2ad78cfb3a964f1d009924187a.png)