What i got is that here in Belgium alot of postalcodes have multiple cities and what Qlikview do for example is:
When postal code "8500" has a price of €50 and postal code contains 10 cities than you have €500 euro but that is not the intention however it is possible that a postalcode is in the .CSV file multiple times.
What i have now is that the SUM results in a price that isn't the right one. How can i filter so that there is one price for one postalcode
Not only the total is wrong but also the detail PIVOT table. You can find a screenshot in te starting post above. Like you see there for example i have sell something to a person with postal code 9700 of 457€ but it is showing the 457€ on every city that has this postalcode and SUM then to.