Thursday, August 25, 2016

Troubleshoot:Calculating a percentage based on row totals not grand total in pivot table

Calculating a percentage based on row totals not grand total in pivot table

Below, the first 2 columns represent my pivot table.
What I want to do is create a calculated field to populate the last column.
That is, what percentage of Bob's time is related to Admin Tasks, Holiday, etc.
The number of "activities" per person can/does
change from month to month.
What is the best way to do this? Thank you!!
 


Row Labels
Sum of Hours
 
Activity %

Smith, Bob
143.00
 
100.00%

Admin Tasks
12.00
8.39%

Holiday
8.00
5.59%

Project Development
0.00
0.00%

Project Management
88.00
61.54%

Project Meetings
0.00
0.00%

Project Travel
35.00
24.48%

Doe, John
120.00
 
100.00%

Admin Tasks
1.00
0.83%

Holiday
8.00
6.67%

Meetings
3.00
2.50%

Personal Time
2.00
1.67%

Project Development
0.00
0.00%

Project Management
87.00
72.50%

Project Meetings
0.00
0.00%

Project Travel
18.00
15.00%

Training Classes
1.00
0.83%

Johnston, Sally
219.00
 
100.00%

Admin Tasks
42.00
19.18%

Meetings
13.00
5.94%

Project Development
0.00
0.00%

Project Management
135.00
61.64%

Project Meetings
0.00
0.00%

Project Travel
29.00
13.24%

Anwsers to the Problem Calculating a percentage based on row totals not grand total in pivot table

Download Error Fixer (Free)

Please take a look at:-
http://www.pierrefondes.com/
  - item 148 where I have just put up a file for you.

 
I think it gives you what you want but not quite in the way that you have asked for it.
 
If you look at the pivot_table Worksheet this is what I think you want: it breaks down each person's activities in terms of percentage time spent on a specific task.
You have also got a total on the right that might be useful.
 
I have explained how to get back to your starting point in the pivot_table Worksheet.
 
In the underlying_data Worksheet columns E to H inclusive are superflous: I just used them to check numbers during the Workbook's construction.
 
If my comments have assisted please vote as helpful.

Thanks.

Windows Error Reporting - To Fix Calculating a percentage based on row totals not grand total in pivot table

  1. Go to Start button.
  2. Open Control Panel.
  3. Go to Windows Error Reporting.
  4. Click on System and Maintenance, then click Problem Reports and Solutions.
  5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
  6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
  7. Next, click the Advanced settings link.
  8. Select Off to turn off Error Reporting.

Another Safe way to Fix the Problem: Calculating a percentage based on row totals not grand total in pivot table:

How to Fix Calculating a percentage based on row totals not grand total in pivot table with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v.2.2.0.0 driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v.2.2.3.0 driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v.2.0.6.22 driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v.1.1.88.1 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: How to Fix - bug in Content Advisor constant pop ups Ratings Pol file?,How to Fix Problem - Bookmarks not being saved?,Fast Solution to Problem: Browsing Issues with Internet Explorer,Tech Support: BSOD (0x8e) by mpfltr.sys,Troubleshooter of Error: Bluetooth problems in windows 8.1,All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work

No comments:

Post a Comment