2 Replies Latest reply: Sep 21, 2015 3:52 AM by Matthias Brink RSS

    Select Postcode Polygon field in map. Filter pivot table with second dimension

      Hi all,

       

      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

       

      Matt