Need some help with calculated fields in a pivot table

[coolkidz33]

I am REALLY trying to become a fan of pivot tables, really. However, there are some things that I cannot seem to do so I am coming here for help. I am not allowed to download anything on my work computer so PowerPivot is not in the cards. Using 2010.

Please see below for an example of my small part of my spreadsheet and the PT:

[TABLE="width: 459"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Customer
[/TD]
[TD]Amount
[/TD]
[TD]% of Qta (amt/4000)
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/15/2014
[/TD]
[TD]XYZ
[/TD]
[TD]1000
[/TD]
[TD]25%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/30/2014
[/TD]
[TD]ABC
[/TD]
[TD]1500
[/TD]
[TD]48%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/1/2014
[/TD]
[TD]FTR
[/TD]
[TD]400
[/TD]
[TD]10%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/15/2014
[/TD]
[TD]FGY
[/TD]
[TD]800
[/TD]
[TD]20%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9/23/2014
[/TD]
[TD]CDE
[/TD]
[TD]2000
[/TD]
[TD]50%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Years
[/TD]
[TD]Quarters
[/TD]
[TD]Date
[/TD]
[TD]Sum of Amount
[/TD]
[TD]Sum of % of Qta
[/TD]
[/TR]
[TR]
[TD]2014
[/TD]
[TD]Qtr2
[/TD]
[TD]Jun
[/TD]
[TD]2500
[/TD]
[TD]73%
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Qtr3
[/TD]
[TD]Jul
[/TD]
[TD]400
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Aug
[/TD]
[TD]800
[/TD]
[TD]20%
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sep
[/TD]
[TD]2000
[/TD]
[TD]50%
[/TD]
[/TR]
[TR]
[TD]Grand Total
[/TD]
[TD][/TD]
[TD][/TD]
[TD]5700
[/TD]
[TD]153%
[/TD]
[/TR]
</tbody>[/TABLE]

I have put it in tabular form and group by M/Q/Y.
Here are my questions:

1. I want my PT to show “Amount” rather than “sum of amount”. Every time I go into field settings and try to change it, it says that name already exists in the pivot table. I want to be able to control the names in my actual PT to anything I want.
2. I want to have another column in my PT that says if I hit a bonus during the quarter. Quota is 4000 per month so for quarter 3 I only did 3,200 against a 12,000 number so the answer is no. I am not sure if you can have text show up in a PT. If not, then July could show 11,600 (12000-400), August could show 10,800 (12000-400-800). Then when it hits a new quarter, it starts over.
3. It always annoys me that pivot tables do not update automatically. Can this changed? I never want to use PTs in my spreadsheets or dashboards fearing that new info will be added and the PT not refreshed and the data will be wrong.
4. How do I make my PT not show the word blank if there is no data. I would rather see 0 or an empty cell.
5. I want to be able to format the cells by putting vertical borders in and making it bold. Every time I refresh, it reverts back.

Some of these things may be very easy but they have been holding me back from using PT's. Thanks to everyone to helps on this board.

Jon

[TABLE="width: 278"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]