Use Aggregate Sum Elsewhere

[Richard]

I searched around for a solutions but I'm not even sure if my description/search terms were well defined enough.  Here is what I have.  Two Grids on a page.  They are for the most part very unlike data so they cannot be in the same grid.  However, there is one column in each that I am using the Aggregate Sum.  What I would like to do is take the Aggregate Sum from one table and add it from a second table and write that off to a textbox/variable for use elsewhere.

Hopefully that makes sense.  I tried screwing around with the footer, but I couldn't seem to find the right combination to grab the information from the footer.

Thanks,

Richard

[Shinu]

Hello Richard,

You can access the footer as GridFooterItem. Check the following help documentation which explains more about this.
Totals in Grid Footers

-Shinu.