Good morning.
I'm trying to generate a row count for two different age ranges. I have a range that goes from 0-34 and then it moves to 9 year increments after that (See Attached) all the way to 95. I can get the count from 0-34, but from age range 35-44 the count starts over from 1 through 9. I would like the count to start at 35-44 all the way to 95 and beyond.
Also is there a way for my count from 0-34 to start at Zero instead of 1?
Thanks for all your help!!!
Solved! Go to Solution.
Hi @SM66215 ,
You simply needed to account for your minimum and maximum ages within each group.
I amended your Generate Rows setup to accommodate this:
I also set your max age on the final group to 120.
This gives you the zero age:
and your ages per group:
Workflow attached,
I hope this helps,
M.