Pivot Table Columns

[Jasmaine86]

Hi There,

Im struggling to find any literture on how to execute the below:

I have a large data set that has all the information I need. These include:
- Sales person
- Job Status
- Sales Price
- Purchase Price
- Profit as a $
- Margin as a %

In the past, i have only needed to report on the Sales person's $ figure and the status of the Job - See Image 1

It has now been requested that i show the Profit as a value $ and the Margin as a %.

I have this information already but am trying to add it to the pivot without it adding addtional columns - See Image 2

I am trying to get it so it will just add the extra two columns (highlighted yellow) in image 3.

I know this is possible but i just cant make it happen.

thank you in advanace!