Filter not working with Calculated items in pivot table

[m83iyer]

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

[alansidman]

Please read the yellow banner at the top of this page on how to attach a file.

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.