HELP in PIVOT Table

[nandhamnk]

Hi All,

Iam using a Pivot table where data contains the following:
Machine
Installed Capacity-ColumnA
Utilised Capacity-ColumnB

and data sheet contains list of various machines ans respective capacities

Is it possible to insert % ( Utilisation ) of columnA on ColumnB in pivot table

Thanks

[VBA Noob]

Hi,

You've not post much info. This link might help.

http://www.contextures.com/xlPivot10.html

If not what your after then ost an example of data with expected results

VBA Noob

[nandhamnk]

Thanks for your reply.

Please find attached Pivot sheet.
In Main sheet,there will be pivot table and
in Sheet1 the details,where Utilisation represents Column C / Column B X 100.
It is possible to arrive utilisation for all machines as a total in Pivot table.

Thanks in advance

[nandhamnk]

Hi,

Can you help me out

Thanks

[nandhamnk]

Hi All

Is this possible

[nandhamnk]

Hi,

Can anybody help me out !

Thanks

[VBA Noob]

Is this what your after

VBA Noob

[nandhamnk]

Thats Great

You did it.Thank you very much

[VBA Noob]

Glad you got your answer

VBA Noob