hi @MJ_RT seeing it sone SharePoint list you can build the tab with a gallery
Consider you need to create tabs which are filters on your data set you could collect the data and then build you tabs like this
Add a horizontal gallery and add two labels, 1 for you tab header and one that will hold the totals
Data source is ClearCollect(colSP4,ForAll(Sequence(1000),{name: "Person: " & Mod(Value,10), score: Rand()*Value*100, zone: Value}))
I created a tab with some conditions (Filter(colSP4,zone<6)), this gives me 5 rows and added the column name as my header, you can use any condition to create a header name (if switch etc) or you can leave your tabs as is.
The totals are based on the conditions you have for each table.
Switch(true,ThisItem.name,
"Person: 1",
CountRows(Filter(colSP4, And(score > 50,Mod(zone,4)>2))),
"Person: 2",
0,
"Person: 3",
CountRows(Filter(colSP4, And(name = ThisItem.name,score > 150,Mod(zone,4)>2))),
"Person: 4",
CountRows(Filter(colSP4, And(name = ThisItem.name,score > 200,Mod(zone,4)>2))),
"Person: 5",
CountRows(Filter(colSP4, And(name = ThisItem.name,score > 250,Mod(zone,4)>2)))
)
Result
Clicking tab 2
Clicking tab 3
In the horizontal gallery i made the font of the totals the same as the back ground of the tab header this way it i shidden when th user i snot clicking on it. I set the colour of the text of tab header to If(Self.Text= MyGallery.Selected.name,RGBA(44, 44, 44, 1), WhiteSmoke) and im filling it Fill = If(Self.Text= MyGallery.Selected.name,RGBA(245, 245, 245, 1), RGBA(44, 44, 44, 1)). Now when th euser click the label the totals show without delay
By doing it thi sway you reduced your control and speed up your app a bit. hope this can work for you. If you choose to keep your app as is, consider to create a collection and derive the totals from the collection not directly from the sharepoint connection
