Grouping based an date ranges

[SpeedRacer]

I have a formula if {Fish.Date} in Date (2016, 08, 01) to Date (2016, 10, 31) then "1st Quarter" else
if {Fish.Date} in Date (2016, 11, 01) to Date (2017, 01, 31) then "2nd Quarter" else
if {Fish.Date} in Date (2017, 02, 01) to Date (2017, 04, 30) then "3rd Quarter" else
if {Fish.Date} in Date (2017, 05, 01) to Date (2017, 07, 31) then "4th Quarter"
When i group, based on the this formula it doesn't always return the data as expected.
Most of the time i get
1st Quarter data data data
2nd Quarter data data data
3rd Quarter data data data

but sometimes it returns 2nd Quarter data data data
3rd Quarter data data data
1st Quarter data data data

or 2nd Quarter data data data
1st Quarter data data data
3rd Quarter data data data

Any Ideas.

 

[BettyJ]

Do you have any other groups above this group?

 

[SpeedRacer]

Yes, Group 1 is Farm, Group 2 Quarter

 

[BettyJ]

That's why - it first groups on Farm and then on Quarter.

I am not exactly sure how you need it, but maybe you can try to combine the groups the way you need by creating a formula like:

@CombinedGroup[tt]
@QuarterGroup &" "& {TABLE.YourFarmField][/tt]

Change QuarterGroup to the name of the formula you have listed in your first post.
Group by @CombinedGroup and delete the other two groups.