In case you want to use your own formula see vba help for "create your own
formula" which will show how to add calculated field in a pivot table.

Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


"Shailesh Shah" wrote:


It is Not Possible.

Workaround is that you use 2 pivotables side by side from the same pivotcache.
Keep requried columns between this 2 pivottables.
Hide neccessary columns from both the pivottables.

Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)


"ni****a" wrote:

How to insert a coloumn in between two existing coloumn in pivot table