Pivot tables count data great but I want to show the results compared to a goal.

I have a pvt table that counts trips that are made to various locations. I added the goals to the data tab so now it counts the trips and the goals together. I want the goals to be negative numbers so the row totals will reflect the travel days left to meet the goal.

The source data has tons of info about the trip (who, where, client info, dates, etc). In this case I am just looking at who and where on a YTD basis vs goal.

Any suggestions on how to do this or a different way to enter the data would be appreciated.

Thank you for all your help.
-Todd