see attached file
Formatting the Pivot Table cells:
a) Is there a way to have subdivision first instead of tasks but not have it group (ie. Laundry groups the clothes and clothes 2)? I want table to sort tasks by Scost 4 from highest to least.
b) I would like to automate the all cells to have a thin boarder but a thick boarder along the outer boarder. you will notice JAS 10 will be a smaller table - is there a way to have it automatically be formatted to look like the longest table?
c) what is the best way to get from Pivot Table to Presentation. Currently I am Copy Sheet then copy and paste values and then switch the sub division with the tasks and format. Is there a way that I can avoid this step by getting to this look in the Pivot Table tab - so when I refresh data it always will have the same format look as in the Presentation Tab?