Addidtional Calculation and Conditional Formating within pivot table

[Excel Dumbo]

Hello,

Please see the attached spreadhseet with the detailed explaination of my problem.

Bacially I would like to include three additional columns in the pivot table and some conditional formating.

Please advise.

Excel Dumbo

[dilipandey]

Hello,

See the attached workbook with desired pivot table

Calculation and Conditional formating with in the pivot table.xls

Regards,
DILIPandey

<click on below 'star' if this helps>

[Excel Dumbo]

Thank you very much Dilip. This is what I wanted. Could you please briefly explain how you added tables within the pivot table and the condtional formating ? Thank you very much again.

[dilipandey]

Hi .. thanks I could help out. Below is the explanation:-

I have used "Calculated Item" option of pivot table to achieve the desired outcome.
Go to Calculated item and select the headings from "Name" drop down and you'll see the formula (logic) used in below field.

After this, I have used conditional formatting as per logic:- if column O is greater or Equal to 100% then Green and if column O's value is less than 100% then Red :-

=O4>=100% for Green

=O4<100% for Red

Hope this helps

Regards,
DILIPandey

<click on below 'star' if this helps>

[Excel Dumbo]

Thanks Dilip. Exactly what i wanted.

[dilipandey]

You are Welcome Excel (not dumbo)

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>