This is driving me nuts.
I have a data set in a collection (TotalsCol) that looks like this (many records obviously)
I want to group it by DayName and display all the service and totals for each day
I have made a gallery with the items set to
GroupBy( TotalsCol, DayName,Meals)
And in that gallery I have tried both a gallery and a data table with their items set to
ThisItem.Meals
The data displays as intended, but in the first row only, it is doubled, a correct display of the meals that day followed by another one. rows 2-7 of the gallery are fine.
I have tried replacing the thisitem stuff with lookups and I get exactly the same behaviour.
What can I do? Is there another control I can use?
