Hello. I have two years in a pivot table with 8 categories. I used a % of parent for year. How can I get pivot table to highlight differences that are above X%? I don't want to create another column that shows the differences. Thnx.
Hello. I have two years in a pivot table with 8 categories. I used a % of parent for year. How can I get pivot table to highlight differences that are above X%? I don't want to create another column that shows the differences. Thnx.
Please attach a copy to help find a solution without having to re-create your data. Remember to remove/replace any sensitive info b before uploading the file.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks