Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I would personally just create another field in your data-model, that's probably the easiest solution.
Regards
Stefan
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