This content has been marked as final. Show 2 replies
i have a sheet with a Pivot table with our turnover per month. Underneath there is a map showing the post code Areas of Germany and the Polygons have a colour changing formula with the changing rate of Revenue per post code area.
All works fine. If I select a post code area the Pivot table filters perfectly on that post code (first two Digits eg. 48 of 48527).
Problem is that there are foreign revenues where the Post code Begins with the same two Digits so that the graphic is correct but the table is not.
Is that possible to say when filter PLZ2 is set the pivot table must also filter on Country code = de but only then?
Thanks in advance