Pivot Table Calculated Field Question.

[srizki]

I have BU (Business Unit) in column A, amount in column B and Budgeted amount in column C. (actually I have 62 columns).
BU is repeated so are Actual Amount and Budgeted.
I am creating a Pivot Table, in that, I am showing actual amount and budgeted amount along with BU. Actual amount adds up and that is correct, but budgeted amount adds up that I do not want.
For example. BU # EP1234, has 73 rows, the actual amount adds up to $80,285.10 and budgeted for this BU is $265,000 but it adds up to $19,345,000 and that is not correct. How can I correct this in to my pivot table.

I have posted this question on MrExcel.com, but still did not get a reply, so I think someone might see this question here and reply.

PIVOT Table Calculated Field Question:



Regards

[Admin]

Hi

Change the calculation type for budget as MAX.

[srizki]

Thank you very much.

I learned something new and important today.

Sohail