Forum Discussion

EmmaE2106's avatar
EmmaE2106
Copper Contributor
Mar 24, 2022

PivotTable percentage column

Hi All,   I currently have the below PivotChart. Column E (% of accounts activated) I've manually entered a formula to calculate C (count of first login) as a percentage of B (count of Employee ID)...
Charting
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 25, 2022

EmmaE2106 If I understood correctly, you want to express the number of first logins for each employee as a percentage of the total count of employees. So, for the row where is says 34 (empl count) and 14 (login) you would expect 2.17% (i.e. 14/646)? If so, you need to use Power Pivot and add some DAX measures. The picture below is just a mock-up of something similar to your pivot table. I have attached the file for reference. DAX measures are not really all that easy to grasp and they are a bit outside my comfort zone, but with some Googling one can get quite far.

 

  • EmmaE2106's avatar
    EmmaE2106
    Copper Contributor
    Mar 27, 2022

    Riny_van_Eekelen no I'm after number of total logins as a percentage of number of people per area (not total number of people), so the first row would be 20 / 135 = 15%. The total row would be 148 / 646 = 23%

      • EmmaE2106's avatar
        EmmaE2106
        Copper Contributor
        Mar 29, 2022
        Thank you. I can't get this to work. Possibly because my "count of first login" is a count of, rather than a number field?

Resources