Total table

I need help with the total table.

If you want a total per user, then you will need to create a Query column with a filter first, and then do a rollup through that.

But, can you explain why you have 5 columns for fish instead of just 1?
That looks like a big red flag to me, that will most likely cause you problems in the future.

Five columns due to five different types of fish

hmm, okay. I would do that differently, but let’s just work with what you have.

Alright, so what you need to do is the following:

  • Create a Math column that adds the values in each of your 5 Fish columns. eg: Fish1 + Fish2 + Fish3 + Fish4 + Fish5. This will give you a total per row.
  • Create a multiple relation column that matches each persons name with itself.
  • Do a rollup->sum through the above relation.

If I get stuck, I’ll ask for help. Otherwise, the best thing would be if you could put it together for me. :grinning:

Okay. Are you just showing me that it works, or did you have another question?

I’m showing it works, but I’ll try another way.