% of parent column total is blank

[Jason_Pinto]

Hi All,
Thank you in advance for your help

I am using excel 2016 version
I am trying to calculate % of column total in pivot table using field settings and it always comes up as blank
My sample data is below
Company Product Cost
A Apples 15
A Bananna 20
A Orange 25
B Apples 10
B Bananna 15
B Orange 20

If i put a pivot and add the cost and use % of parent column it always comes up as blank ( please see image attached)
Company Product Sum of Cost Sum of Cost2
A Apples 15
A Bananna 20
A Orange 25
A Total 60
B Apples 10
B Bananna 15
B Orange 20
B Total 45
Grand Total 105


Thank you again

 

[vletm]

Jason_Pinto
After copied & modified Your sample photo.
I tried to make 'Your kind of Pivot' ...
It took less time than 'copy & modify'!
Something like this?

ps. A sample file would be good to have from You.

 

[Jason_Pinto]

Thank you, I was trying to use % of parent column total whereas % of parent row total provides the correct results. I was assuming that we need to look at column total hence the issue
thank you for your reply