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?