Forum Discussion

oren's avatar
oren
Icon for Helper III rankHelper 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

Asac_14's avatar
Asac_14
Icon for Resolver I rankResolver I
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
    Icon for Helper III rankHelper III
    6 years ago

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

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

      • oren's avatar
        oren
        Icon for Helper III rankHelper III
        6 years ago

        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!