Duplicate Values between Different Tables

[zakunz1]

Hello all,

I'm attempting to bring in two different tables that are both joined via a relationship via a unique ID to tie the items together.  What I'm now getting is if I attempt to build a matrix that separates those values out from Table 1 based on another value from Table 2, I get the grand total in each category:

Is there some way I can get the distinct values of each category from Table 1, while the categories are coming from Table 2?

[Anonymous · Accepted solution]

Hello!! First, based on your information, try to change the cardinality of your relationship to both on the "manage relationship" option pane.

[Anonymous · Accepted solution]

Hello!! First, based on your information, try to change the cardinality of your relationship to both on the "manage relationship" option pane.

[zakunz1 · Accepted solution]

@Anonymous - That was it.  Thank you very much.