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

[#1]

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

[Stefan_Walther]

I would personally just create another field in your data-model, that's probably the easiest solution.

Regards

Stefan

[#3]

There is a second field in the Dataset but it must automatically be filtered when selecting the Postcode Polygon in the map in order to filter the Pivot table correct.

Best regards

Matthias