Hello Community. I have a problem with a relationship that I guess could be the cause of my problem. So I needed two columns that were on different tables. So after merging using a Primary Key, and loading the column I wanted on a table, I am experiencing that or some values are correct in the table visual for that column. However, other values, bring the total in the table visual for the same column. The Visual table(Report Tab) below shows what I am explaining:
| Primary Key | column1FromTable1(text) | column2FromTable1(text) | column3FromTable1(text) | column1FromTable2(Value) | column2FromTable2(Date) | column3FromTable1(Column of interest) |
| 1 | CLient A | Product A | State A | RevenueA | ForecastprojectcloseDate1 | 39456 |
| 2 | Client B | Product B | State B | RevenueB | ForecastprojectcloseDate2 | 34662 |
| 3 | Client C | Product C | State C | RevenueC | ForecastprojectcloseDate3 | 89534 |
| 4 | Client D | product A | StateB | RevenueD | ForecastprojectcloseDate2 | 56,784,465 |
| 5 | Client E | product C | State D | Revenue B | ForecastProjectCloseDate4 | 45510 |
| 6 | Client F | product B | State E | Revenue E | ForecastProjectCLoseDate1 | 56,784,465 |
As you can see for Primary key 4 and 6 , the far end column on the VIsual table has a very high value. This value is the total for that column. I am more used to the total showing for the whole column when a relationship does not work. But now this relationship is somewhat working partially. Any ideas to solve this?
