Forum Discussion

oren's avatar
oren
Helper III
6 years ago
Solved

different values to same table

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 ?    Than...
Need Help
  • Asac_14's avatar
    Asac_14
    6 years ago

    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's avatar
oren
Helper III
6 years ago

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's avatar
Asac_14
Resolver I
6 years ago

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's avatar
    oren
    Helper III
    6 years ago

    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)