different values to same table

[oren]

HI

i have excellently same 2 tables

when  i  put the data together  is same matrix - one is give me the data i want and one is summarize all data in all rows 

what is the reason ? 

Thank you!

[Asac_14 · Accepted solution]

Hi @oren  You should have a relationship between both the table else total value will be repeated for each row like your matrix. Accept this as solution if this solves your problem.

Thanks & Regards,

Karthick K

[oren]

i did it and its works :

but why it didn't work for me when is did the relations with another table ??? (see below)

thanks!!

[Asac_14]

@oren  Try making the filter bi directional. By the way what is there in ID Column ?

[oren]

Try making the filter bi directional.

i works now! thank you!

By the way what is there in ID Column ?

it have unique numbers {1,2,3...} (so i can sort the test% by that)

thank you!

[Asac_14]

Hi @oren  Can you please mark my previous reply as solution.

Thanks.

[oren]

i checked it again

the problem is that i can do it for only 1 relations

if i try to do it to another value (like "TEST%") its a problem  :

[Asac_14]

Have you removed the intermediate table ? you can't have two relationship between two tables. May I know why are you creating two relationships between these two tables ?

[oren]

again,

my first problem was the i got a wrong data-  so your solution was to make relations ,

it did help but only for the specific category , if for example i want to use a different category , i again getting a wrong data (see in yellow)