Hi

I have a pivot table ready with the following columns

Year, Region, Product, Country, Detail, Value - Ofcourse - Year, Region and Country header are quite obvious in content.
Under Detail - I have bunch of revenue tagged as My Company, Total market and RoM (Which is ofcourse Total mkt - My company)
Under value - All USD figures

I inserted calculated item under the field (Detail) to calculate Market share - formula - My Company/Total Market

It works fine as long as I use Region/Product/Countries filters individually but what I ideally want is that the pivot should display only those countries tagged under the highlighted region but at present it shows the entire list of countries irrespective of which region I select and this affects my pivot chart.

Is there a workaround to this

Thanks in advance