LinkBack URL
About LinkBacks
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
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
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>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
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.
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>
Thanks Dilip. Exactly what i wanted.
You are Welcome Excel (not dumbo)
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks