insert a coloumn in pivot table
How to insert a coloumn in between two existing coloumn in pivot table
|
insert a coloumn in pivot table
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 |
insert a coloumn in pivot table
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 |
All times are GMT +1. The time now is 07:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com