Forum Discussion
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
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.
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 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!
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?
Justin_Yost Great! Glad you could figure it out.
