Pivot - Show values as % of parent row without showing other rows

[bukimi]

Hello,

I have a pivot table that shows categories of products and then lists producers.
Values are shown as % of parent row - that is, I get to see share of each producer (%) in every category. Columns are weeks.

Category	Producer	Week1	Week2
Fruit	CompanyA	40%	45%
Fruit	CompanyB	30%	35%
Fruit	CompanyC	30%	20%

That's fine.
But in final table, I need to see only results for company A, for all categories, without showing share of other companies.
If I filter out CompanyA, I automatically get 100% share shown, as it's the only element left under parent row. There are different companies in different categories, but CompanyA is in all of them.
Is there a way to work around it to get it right, even using PoverPivot, so I get something like table below? (of course data for other categories are not shown in table above)

Category	Producer	Week1	Week2
Fruit	CompanyA	40%	45%
Vegetable	CompanyA	42%	56%
Sweets	CompanyA	31%	29%

 

[bukimi]

I did it! Don't want to erase thread "just like that", so I'll post a solution instead.

1. Add a new column in source data, that is a SUMIF for values only for companyA. So, sales for CompanyA are shown normally, all other are always 0 (zero). Let's name it "Sales CompanyA".
2. In final Pivot Table, add a new Data field that is calculated as "Sales CompanyA"/"Sales (total)". That way, we get % share only for Company A, ignoring values of other ones.