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.
