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!

      • Asac_14's avatar
        Asac_14
        Icon for Resolver I rankResolver I
        6 years ago

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

         

        Thanks.