Numeric grouping in pivot tables

  • Thread starter Thread starter redrum
  • Start date Start date
R

redrum

I see that I only get the option to group items from a number to a number
when all my data is numeric. Problem is that because I don't know how many
rows my data will have (I want to be able to paste in new values and just
'refresh' the pivot table), I have used the source "$A:$H".

Is there a way to have a range for my pivot table source that will allow me
to pick up any number of rows but and get the numeric grouping feature?

Thanks in advance for any pointers.
 
Select your source data and
Excel 2003 Data > List > Create List
Excel 2007 Insert > Table
When you paste data at the * of the List
or delete rows of the List,
the Pivot Table range will adjust automatically.
Here is a sample file with Date being grouped.
http://www.freefilehosting.net/download/3bb1m
 
hi
Regrettably this feature (List) only came in with XL2003

You can create a Dynamic named range to achieve the same thing.
Insert>Name>Define>Name lastrow Refers to =COUNTA($A:$A)
Insert>Name>Define>Name MyData Refers to =$A$1:INDEX($H:$H,lastrow)

Your data range will grow as you add more lines.

With the PT, right click on PT>PT Wizard>back>Data =MyData>Finish
 
Thanks for that. Very useful.

Roger Govier said:
hi
Regrettably this feature (List) only came in with XL2003

You can create a Dynamic named range to achieve the same thing.
Insert>Name>Define>Name lastrow Refers to =COUNTA($A:$A)
Insert>Name>Define>Name MyData Refers to =$A$1:INDEX($H:$H,lastrow)

Your data range will grow as you add more lines.

With the PT, right click on PT>PT Wizard>back>Data =MyData>Finish
Click to expand...
 
Back
Top