Calculate the correct total of a column

[KoopaTroopa]

Hi all,

I have the problem that the total in my visual table doesn't calculate the correct value.

The reason is that the values in column "n=" are extracted from a lab managment system and I have to choose "maximum" to display the value I actually want. Otherwise I would have several lines with different values for every topic. I guess that's why it also displays the maximum as total. 

Is there a possibility to just sum up the values displayed in the table? It would also be fine to do that with another visual if that's easier. 

Any ideas?

Thanks in advance.

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=6rgAkejrup8

[KoopaTroopa]

The whole table looks like this:

As I said, everything is a dataflow extract of a lab managment system. The list shows me all open requests with lab tests to be made and n is the number of replicates to be tested per method.

[bsheffer]

not sure what determine the value of N for the row.  can you restate?  What is the "primary key" for the row