I want to get % of one item in pivot table ( % Of Total)

[Ram Mher]

Hi everyone
I have date in column A, Items in Column B and C and Total in column D.

I need to know that how much % share is of 1st item. This result i need through pivot ( Hint- % of Total). File is attached .

 

[Swapnil]

You can do so with the help of calculated field, Attaching the screenshot as well as working file for your reference.

 

[Ram Mher]

Thanks for the solution.

 

[Ram Mher]

Thanks for the solution.

Dear Swapnil

Please refer the attached file and provide the solution.
In the previous example i wanted to know % of one item but in this case i need to know percentage of each item on the basis of Total of each item.

 

[Swapnil]

Same procedure ... Please see the attached file

 

[Ram Mher]

Dear Swapnil
Now i want to calculate the Percentage of each shift from data base after making a pivot from the data base. please refer the attached and provide any idea.
thanks for the previous solutions