Skip to main content

Showing Column Sum in one table to another

  • May 5, 2023
  • 1 reply
  • 17 views

Forum|alt.badge.img

Hi Community,

I am looking to have a total sum of 1 column to reflect on a row that will match item number for another table

If you look below at the snapshot images, the 1st table provides assessments for sites and I formulated a square yard number under each column (C202(52)(C) - Removal and Disposal of Existing Portland Concrete), (C202(52)(D) - Removal and Disposal of Existing Sidewalk...

I am looking to have these total summed up quantities to reflect another table as shown on the second image, under the Total Assessment QTY linked accordingly to the item number

Any advice would be greatly appreciated!!!  

 

 

 

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

After you've linked the records appropriately, you can use conditional rollups with `SUM(values)` to get what you're looking for I think