Getting so confused looking at this simple table and have tried so many ‘grouped by’ iterations I’m too tired to see the solution.
Thing = Dog
field one: breed (option set)
field two: desex date
Any ideas how to set up my repeating group/s to display the number of dogs desexed per month by their breed?
Not sure if this could help. It is group by Date & by Text?
Aggregation is on the right path but how to do the 12 columns?
I am trying to use a nested repeating group but cannot access ‘a list of groupings’ and can’t get the count for each month…
Will add the solution for future readers in the morning.
Thanks to @charless for the aggregation tip!
This topic was automatically closed after 70 days. New replies are no longer allowed.