Mission Impossible ? Pivot Table at front end Excel

I have a table with this field headers Product/Status/USD:-

A/Actual/100
A/Budget/90
A/Variance/10

I have created a Pivot Table in Excel with
Product as row field (A or B)
Status as Column field (Actual, Budget, Variance)
USD as Value

It looks fine like this but I need to create a column called Variance % which is (Variance/Budget x 100%).

Please urgently advise how to create this new % column within Pivot Table.

Thanks. Sorry it seems a bit more about Excel but can't get answers in Excel forum...

I am not using SQL Server.

help...

Sorry, but I think your chances better off with trying Excel forum.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Missing Header Footer in

Hey all-

We have a number of reports that have headers and footers in HTML and PDF, but when exporting to Excel the headers and footers disappear.

Has anyone else seen this happen? Any ideas on how to re-enable the headers?

Thanks in advance,

Tristan

Tristan, did you find a way to do this? I am in a very similar position where the footers are not displayed.

Thanks,
AJ