Yes, the Georaphical area variable is in the view. The view simply counts the distinct number of Suppliers per Geographical area. What I want is to have a filter or a parameter that shows the full data, but only for the Geographical area where a particular Supplier is present.
Each Geographical Area has many Suppliers, but the particular supplier (lets call it Supplier X) is not represented in all Geographical areas. The filter should have only two options; Show all Geographical Areas or Show only Geographical Areas where Supplier X is present. The view must still show the full data, not limited to counting only Supplier X, but showing the count for ALL Suppliers.
Another possibility would be to split the view, so that one pane shows Geographical Areas where Supplier X is present and the other pane all other Geugraphical areas.
I can't post the Workbook, since it contains sensitive data. I thought this would be simple enough without posting it, but if needed I will mockup some data and reconstruct the view from this dataset to be able to show what I mean.