Help with pivot table

Please forgive me I know this must be very basic for most of you but I really have been scratching my head all day on this ie and its not coming out as expected
I want to create a pivot table which will rank in the following order
1. Rank of App with Highest to lowest based on usage across the 3rd parties listed in col A
2. Rank of 3rd party from highest to lowest based on app usage/number of users


Guess this must be simple but when I do it its not providing clear results. For instance, there are 177 users across the board of 3rd parties using confluence when I calculate this manually. my pivot table is not showing this. so I obviously dont know what values to use to bring this out
thanks for any suggestions ...and hope I'm clear in my ask?

Aaah now I understand.
so what would be the best way of me achieving my desired output/report in excel without having to do it manually?
I only provided a snapshot of what the actual data is and it will take many hours if I to do it manually.

Just wondering, but what's the shape of your input data? Could you sketch that out or provide a sanitized sample? (like fewer apps and/or groups, and no real names or anything). Don't want to get anyone in trouble. But you could do counts DAX and then use RANKX() to rank your apps over groups for example.