Grouping to included ranges for which no base data exists

G

Gerry

I have a set of data which has numbers ranging from 1700 to 32100.
I'd like to pivot table them and group them in bands of 100, starting
at 1700. I'd like my pivot table to show all of the bands that
exist. The problem is, if I have no data within the band 2200 to 2300
that band wont appear in my grouped pivot table. Any help most
appreciated. Thanks in advance. Gerry.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xml transforms to rearrange worksheet data? 0
How to get two different grouped pivot tables from the same datatable? 6
Adding additional column of data to pivot table 1
Pivot Table Mapping 1
Pivot table grouping 4
Code for creating field when no value exists 4
No grouping in pivot table (?ungroup?) 3
Pivot Tables with different groupings based on same data table 6

Top