I don't see why you are bothering to reset it after the last pulse. It does that itself, in that the next count after 9 is 0.
If you want to count up to smaller numbers, you connect the next output, the one that you don't want to come on, to the reset line.
For instance, if you want to have 4 outputs only, they would be 0, 1, 2 and 3. If you connect output 4 to the reset line, then on the next pulse after 3 you will get 4 for only a few microseconds before it resets to 0.