View Single Post
 
Old 06-22-2016, 04:47 AM
bremen22 bremen22 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Question Showing percentages in a pivot table

I am trying to calculate reliability percentages. I have a table that shows each piece of equipment, the date is was scheduled to be used, and the date it was actually used. There are several pieces of equipment that we are tracking. My end state is to show a chart of this data.

In my pivot table I am showing the piece of equipment, the count of the days it was scheduled for use, and the count of the days it was actually used. I want to show the information as percentages.

For example:

The tractor was scheduled for use 4 days this week. For whatever reason it was only available 3 of those days it was scheduled. In my chart the end result I want to see is for the tractor a bar showing only 75% availability. I cannot, however, figure out how to only show that 75%.
Reply With Quote