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 ? 

 

Thank you!

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

8 Replies

  • 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 ?