Column Sum with Sum appearing on another table


#1

I am trying to add up my column ‘clip total’ in the ‘James Adams’ so that I can display the SUM on the ‘producers total’ table for multiple producers. How do I do this I cannot figure it out.


#2

Maybe you’re talking about Rollup?


#3

Hey Thanks. I have the rollup working but do I have to manually add in all the Records? Is there way to batch a full section or mall 100+ records?


#4

I think I misunderstood your situation.

  • Why can you bring the summarizing data to another Table? Is it not enough to have it the bottom bar?
  • I also recommend to have a Producers table, so you could break down information by Producer (like a Total Clips with the Rollup).