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!
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!