Thread: Pivot Table - Single Value in Value Field

Hi guys, have been scratching my head with this one . . .

Im trying to create a Pivot table with two fields in the values section.
One entry being the Invoice Amount, the other being the waiver amount.
The waiver amount needs to be split out into the different reasons, ie. Commercial, Nonprog, Other etc.

I firstly add the the reason field to the column label section, i get the "reason" field to the column labels, then added the first Amount field (Waiver Amount) to the values section. So now i have the Waiver amount, split into the different reasons, as per the column labels.

When i add the second the amounts field (Invoice Amount) to the values section, Excel splits the Invoice Amount into the "Reasons" Which is not what i want. I would like the first amount field split into the reasons as per the column field, but when i add the second amount field, i would want it to not split into the different reasons as per the column labels.

Is it possible to have excel to show the one amount field as a total, and split out the amount field as per the column label "reasons" ?

Attached is an example of the problem i am facing!

Any help will be appreciated . . . .im stumped!

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!