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 🙂
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 🙂