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.
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.