Help on Project Status summary in gallery

[echodapogi]

Hello Team, Newbie here. i have issues on summarizing my project status in the gallery. I appreciate any help. Much appreciated if you have code to share. 

here is my table

Project Name	Assigned To	Project Status
Migrating to SQL	Person 1	Pending
Coding Power Apps	Person 2	Not Started
SharePoint List	Person 1	Completed
Project Oakdale	Person 3	Not Started
Azure	Person 1	Pending

I need a summary of that like in this view

Assigned To	# of Project Owned	Completed Status	Pending Status	Not Started
Person 1	3	1	2	0
Person 2	1	0	0	1
Person 3	1	0	0	1

[gabibalaban]

Hi @echodapogi ,

Set your Gallery ->Items:  GroupBy(MyTable,"AssignedTo","Result") 

Inside your gallery insert 5 labels that represint and should be defined like this :

1. AssignedToLabel - > Text: ThisItem."AssignedTo"

2. ProjectOwnedLabel -> Text: CountRows(ThisItem.Result)

3. CompletedStatusLabel -> Text: CountRows(Filter(ThisItems.Result,'Project Status'="Completed"))

4. PendingStatusLabel -> Text: CountRows(Filter(ThisItems.Result,'Project Status'="Pending"))

5. NotStartedLabel -> Text: Text: CountRows(Filter(ThisItems.Result,'Project Status'="Not Startes"))

Also you have to put outside the gallery the name of the columns in separate labels.

Hope it helps !

[echodapogi]

let me try that now.

[echodapogi · Accepted solution]

Wow. Works like Magic!!!!. I really appreciate your quick response. THANK YOU!!

[gabibalaban]

Hi @echodapogi again :), 

Please don't forget to mark as solved if my solution meets your expectation.