Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default insert a coloumn in pivot table

How to insert a coloumn in between two existing coloumn in pivot table
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I insert a row in a pivot table? Deanna Excel Worksheet Functions 4 February 17th 07 07:20 AM
Insert formula in a pivot table Nelson Excel Discussion (Misc queries) 5 February 9th 07 06:03 PM
PIVOT TABLE HOW TO INSERT....... drhell Excel Discussion (Misc queries) 2 January 30th 07 01:02 AM
Insert a row after a pivot table MarkM Excel Discussion (Misc queries) 0 July 19th 06 09:19 PM
Insert column in Pivot Table NewExcel2003User Excel Worksheet Functions 1 November 24th 04 11:20 AM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"