LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 271
Default Excel Pivot 2007 Report Format


I am trying to format pivot to better display of an Event Timeline. I have
one Pivot by Category, Sub-catetory, etc. and the other Pivot by Date, Tim,
Categ, SubCateg.

My Event Committee are reading the blank indents as "missing" informatiion.
The Design color options do not help. I have also tried the Setting the
Field Options for the Columns to indent.

eg.
Category Sub-catg Date Action
Budget Budget 20-Feb Set up budget tracking report
Committee Auction Gifts 20-Feb Coordinate sales of ads/gifts
6-Mar Coordinate with Allison
CommitteeRoles 6-Mar Pull more volunteers, target Organizer
20-Feb Quick review of Committee Roles

Looking to do something like this:
Category Date Action
Budget
Budget 20-Feb Set up budget tracking report
Committee
Auction Gifts 20-Feb Coordinate sales of ads/gifts
Auction Gifts 6-Mar Coordinate with Allison
CommitteeRoles 6-Mar Pull more volunteers, target Organizer
20-Feb Quick review of Committee Roles
--
Susan
 
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
Report Format - Pivot Table not working Melissa Excel Discussion (Misc queries) 4 August 29th 08 03:24 AM
pivot table report not valid when opening xls created in 2007 JP Excel Discussion (Misc queries) 0 August 28th 08 04:14 PM
Excel 2007 Pivot table's Report filter fields value sorting Amigo New Users to Excel 1 October 16th 07 09:10 AM
Pivot tables - Format Report hiunnati Excel Discussion (Misc queries) 1 May 13th 06 04:46 PM
Pivot tables - Format Report hiunnati Excel Discussion (Misc queries) 0 May 13th 06 02:23 PM


All times are GMT +1. The time now is 03:03 PM.

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"