@mrQ
You can but you can make it display in galleries like that. Not sure what you need it to do. Here is how:
Gallery 1:
SortByColumns(GroupBy(AddColumns(DataSource, "DateMonth", Month(DateField),"DateYear",Year(DateField)),"DateMonth","DateYear","GrpByDAte"),
"DateYear",Ascending,"DateMonth",Ascending)
This gallery can have two labels in it:
1)Switch(ThisItem.DateMonth,
1, "Jan",
2, "Feb",
3, "Mar",
4, "Apr",
5,"May",
6, "Jun",
7, "Jul",
8, "Aug",
9, "Sep",
10, "Oct",
11, "Nov",
12, "Dec",
"")
2) ThisItem.DateYear
The OnSelect for them needs to be: Set(varMonth, ThisItem.DateMonth); Set(varYear, ThisItem.DateYear)
Then you can have a second gallery that groups by the categories but also filters for only ones who have the Month and Year matching the variable you set on Gallery 1 OnSelect.--- The Filter portion would be something like: Filter(DataSource, Month(DateField) = varMonth && Year(DateField) = varYear)
The third gallery could not have any grouping...just filtering off the date variables and then a variable set off the "Category" selected in Gallery 2. It just really depends on what all you need do with it...there are a few ways you could make this work.
The one I did just has several layers of filtering so it gets a similar result you are wanting but a different way of going about it. Just have to think outside the box.
I have one that does a collection of all the data and each time they make a selection (from a gallery) it removes the items that do not fit that criteria....allowing them to filter multiple fields.
