Forum Discussion
Remove Duplicate Values in Column
gmasta1129, two ways to achieve what you're after is:
1. Create a unique key that merges Client ID and Post Code, OR
2. Use MAX to return the maximum amount for the respective Client ID.
Firstly, though, I recommend you attempt the earlier options I provided so that assumptions are tested for fact and proven not to work.
All the best with your challenge.
Theo 🙂
Hi gmasta1129
Okay, no worries. The reason the $10,000,000 is showing is because you have two distinct Post Codes for Client 1. Client 1 has Post Code 1111 and Post Code 1112 and each of these have $5,000,000 (therefore, $5m x 2 = $10m). You can do either of the following:
- Create a Key using calculated column ( Column = Table[Client] &" " & Table[Post Code] ) OR
- You can remove the Post Code column from your table OR
- Correct the Post Code on Client 1 so that Client 1 only has one Post Code.
Hope this helps 🙂
Theo
TheoC I dont think those will work since i have other columns i am pulling into the table. The example above was just a short version but i have about 10 more columns where the other columns need to pull in data for both 1111 and 1112. so for example, another column in the report is titled cash. I need cash to pull in for client 1 from both portfolios (1111 + 1112) but then for eligible amount, i only need the value from portfolio code 1111.
gmasta1129, two ways to achieve what you're after is:
1. Create a unique key that merges Client ID and Post Code, OR
2. Use MAX to return the maximum amount for the respective Client ID.
Firstly, though, I recommend you attempt the earlier options I provided so that assumptions are tested for fact and proven not to work.
All the best with your challenge.
Theo 🙂