Forum Discussion
Justin_Yost
Jun 08, 2020Copper Contributor
Percentage of count inside a Pivot table
Is there a way to get a "running" % of completed visits inside a pivot table based on the count. Example
- Jun 08, 2020
Justin_Yost Assuming you are on a Windows system (i.e. not Mac), make sure that "Add this data to the Data Model" is checked (see picture, bottom left).
Then create the PT as in your example, but leave out the last column. Then add a 'Measure' to the table in the
Name the measure and enter the DAX formula required
Add the Measure field to the PT and format it as a percentage. Then it should look like this:
The attached file contains the example shown above.
Riny_van_Eekelen
Jun 08, 2020Platinum Contributor
Justin_Yost Assuming you are on a Windows system (i.e. not Mac), make sure that "Add this data to the Data Model" is checked (see picture, bottom left).
Then create the PT as in your example, but leave out the last column. Then add a 'Measure' to the table in the
Name the measure and enter the DAX formula required
Add the Measure field to the PT and format it as a percentage. Then it should look like this:
The attached file contains the example shown above.
- MandiA15Oct 04, 2023Copper Contributor
Riny_van_Eekelen I love this concept, and I learned something new! Thank you for this post.
I am trying to leverage this functionality with my data set, but I am struggling to set it up in a way to get what I need from it. Hoping you can assist.
I am looking for a compliance rate for teammates within their specific Default Group. My data is pulled so that I have the Teammate and Default Group with their weekly timesheet hours submission. The goal is to be at least 40 hours per week.
Data set with hours subitted
Then, we calculate what the compliance rate is based off of the number of teammates that submitted 40+ hours/# of Teammates in the Group.
Compliance rate percentage
Instead of using a manual calculation, I was hoping to use this method. However, I cannot figure out how to get the data setup and create a usable formula. Any assistance would be greatly appreciated!
- Riny_van_EekelenOct 05, 2023Platinum Contributor
MandiA15 Not sure I follow, and since the last post a lot has happened to Excel. Perhaps the Data Model / DAX measures route is not needed in your case.
What Excel version are you using? What platform? Can you share a file (without sensitive information) via Onedrive or similar?
- MandiA15Oct 05, 2023Copper Contributor
Riny_van_Eekelen Thank you for your quick response!
To answer your questions:
- What Excel version are you using?
- Microsoft® Excel® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20182) 64-bit
- What platform?
- Microsoft Windows 11 Enterprise
- Can you share a file (without sensitive information) via Onedrive or similar?
- I have sent you a sample file.
- What Excel version are you using?
- Justin_YostJun 08, 2020Copper Contributor
- Riny_van_EekelenJun 08, 2020Platinum Contributor
Justin_Yost Great! Glad you could figure it out.