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). Is there a way I can add a column in the PivotChart itself to do this calculation for me? Most tutorials I see adding a column to calculate % in a PivotChart give a percentage by row that adds to 100%, but that's not the case here. I'm calculating how many employees have activated their account, so 100% = 646. 

 

 

Charting

8 Replies

  • 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%

Resources