Hello guys !
I have a table in SharePoint list like this:

i need to add in my power apps like this:
FILTER: GROUP 1 and "SUM" considering "COMPLETE / TOTAL" activities

how can I show this data, since each group can change the number of companies it has by varying the number of columns displayed ?