LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
SC
 
Posts: n/a
Default How do i automatically group rows in a pivot table?

I have a pivot table with a long set of rows (200). I'd like to group them
into 10 groups, almost like a histogram. Is there a way to do this? The only
group function appears to be manual. And I don't see any way of doing it
using the show-top-X summarization feature.
 
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
updating pivot table to include additional rows Ellen Excel Discussion (Misc queries) 8 July 15th 08 01:33 PM
OLAP Pivot table - How to show items with no data ? Timmo Excel Worksheet Functions 1 March 30th 06 06:03 PM
Getting Pivot Tables to automatically sort rows in alphabetical order Kei Excel Discussion (Misc queries) 1 March 9th 06 05:24 PM
Pivot Tables & not printing blank rows (revisited) [email protected] Excel Discussion (Misc queries) 1 August 4th 05 07:42 AM
Pivot Table - max rows allowed in data range dmotika Excel Discussion (Misc queries) 2 May 26th 05 05:52 PM


All times are GMT +1. The time now is 11:27 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"