Diving Subtotals in a Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-1886204%22%20slang%3D%22en-US%22%3EDiving%20Subtotals%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1886204%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20needing%20help%20dividing%20subtotals%20in%20a%20pivot%20table%20by%208.5.%20I%20Have%20a%20pivot%20table%20that%20shows%20me%20the%20total%20amount%20of%20hours%20(equal%20to%208.5%20hour%20shifts)%20that%20were%20worked%20each%20day%20of%20the%20month%2C%20but%20I%20also%20need%20to%20know%20the%20number%20of%20people%20who%20worked%208.5%20hour%20shifts%20each%20day.%20I%20know%20I%20can%20get%20that%20number%20by%20dividing%20the%20subtotals%20next%20to%20each%20date%20by%208.5%2C%20but%20I%20don't%20know%20how%20to%20create%20the%20field%20to%20make%20that%20happen.%20I've%20attached%20my%20excel%20sheet%20for%20further%20help%2C%20or%20for%20other%20ideas%20to%20achieve%20this%20goal.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1886204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1886274%22%20slang%3D%22en-US%22%3ERe%3A%20Diving%20Subtotals%20in%20a%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1886274%22%20slang%3D%22en-US%22%3ENever%20mind%2C%20I%20solved%20it.%20I%20added%20a%20count%20function%20to%20the%20date%20field.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm needing help dividing subtotals in a pivot table by 8.5. I Have a pivot table that shows me the total amount of hours (equal to 8.5 hour shifts) that were worked each day of the month, but I also need to know the number of people who worked 8.5 hour shifts each day. I know I can get that number by dividing the subtotals next to each date by 8.5, but I don't know how to create the field to make that happen. I've attached my excel sheet for further help, or for other ideas to achieve this goal. 

1 Reply
Highlighted
Never mind, I solved it. I added a count function to the date field.