LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default combine column labels in pivot table

I have a pivot table where the column labels are the event date. There can
be more / less event dates based on the range of data selected. Under the
column label for each date will be a sales count, a sales $ and a cost $
value.

How can I get the date to "Center Across Selection" of the 3 values when I
never know how many sets of data I will have?
 
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
Can pivot table column labels be filtered? terri.hirsch Excel Discussion (Misc queries) 1 August 14th 08 04:43 PM
Like items will not combine in a pivot table. markh Excel Worksheet Functions 4 April 1st 07 06:06 PM
How do I combine two speadsheets into one pivot table Eqa Excel Discussion (Misc queries) 0 March 28th 07 01:09 AM
how do I combine two pivot table? Lisa Excel Worksheet Functions 1 August 22nd 06 10:29 PM
Can I combine two worksheets into one pivot table? Todd Excel Worksheet Functions 1 December 22nd 04 10:12 PM


All times are GMT +1. The time now is 04:47 AM.

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

About Us

"It's about Microsoft Excel"