Hello. Is there a way to automatically format each level of the pivot table differently. For example, for row levels there is country, then city (cities sum to countries) Can I format ALL the total country rows differently?
Hello. Is there a way to automatically format each level of the pivot table differently. For example, for row levels there is country, then city (cities sum to countries) Can I format ALL the total country rows differently?
Annex show what you want to achieve
I think some of the pivot table styles will give the result you want. Have a look at the attached example. I did this by clicking on the Design ribbon and selection the "PivotTable Style" I wanted to apply. I had to scroll through the icon samples to find the right one.
Good luck with it!
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