Pivot Table - Group by tens, but include zero?

[Chasden]

Hi,
I am making a Pivot table to show a count based on ranges of values. Everything is fine, except that this particular data contains 0 values.
I want the ranges to be "natural," so 11-20, 21-30, etc. but this puts the 0 values in their own row as <1.
If I change the ranges to start at 0, I get ranges that don't look nice (0-9, 10-19, 20-29, etc.) Using increments of 11 is even worse!
Is there a way to get the first range to include 0 (0-10), and then the rest go by tens (11-20, 21-30, etc)?

Thank you!

 

[RoryA]

You'd have to use a lookup table. You can't have uneven grouping bands.

 

[Chasden]

Are you talking about something like

=COUNTIF(B:B,">0 AND <10")

(or however it's done in excel, I'm on my phone)?

If not, then I'm not sure what you mean.

 

[Chasden]

You actually can have uneven grouping bands, but only at the end of the data for some reason. See the last row of the screenshot below, which contains 11 years in the last row. I didn't do anything special to make it happen. This is why I asked if it can also be done to the first row.

 

[RoryA]

No, it can't. It will allow one extra in the last group (not sure why to be honest) but not the others. I was suggesting a lookup table - two columns: the first will be the lower bound of each banding and the second will be the description you want to show.