1 person found this helpful
If you just want to report the concentration for one compound in particular, then the simplest way to approach this would be to set up a filter on the group containing the concentration field for the compound name. If your concentration field is not in a group, you can right-click and select the option to 'Group' to create a group containing the field. Then right-click on the group and go to Properties.
In Properties you can choose to repeat the group on Compound_Name, then go to the Filtering tab to set a filter for Compound_Name = API. Then only the concentration for API should be reported.
Thank you Ryoboyle,
it worked. I only need to figure out, how I can do it, without using a matrix and filter all out.
It kinda get very complicated, for me to explain to others, how to use it properly. ( maybe that saves my job )
I still try to figure a perfect way to solve this, but with this help it gets much easier.
Thank you very very much