Can anyone tell me if the table is set up correctly to give me the % of the row total for # Correct and # of Errors or am I doing something wrong? All I get is 100% with I try to do a % of row total. It works for % of Parent though. Thanks! It wouldn't let me upload an excel file - sigh. Having a bad day.
| Month/Year | Month | Year | # of Errors | # Correct | Total # Widgets |
1/1/2017 | Jan | 2017 | 17.00 | 93.00 | 110.00 |
1/2/2017 | Jan | 2017 | 14.00 | 106.00 | 120.00 |
1/3/2017 | Jan | 2017 | 12.00 | 118.00 | 130.00 |
1/4/2017 | Jan | 2017 | 10.00 | 130.00 | 140.00 |
1/5/2017 | Jan | 2017 | 9.00 | 141.00 | 150.00 |
1/6/2017 | Jan | 2017 | 8.00 | 152.00 | 160.00 |
1/7/2017 | Jan | 2017 | 6.00 | 164.00 | 170.00 |
1/8/2017 | Jan | 2017 | 4.00 | 176.00 | 180.00 |
1/9/2017 | Jan | 2017 | 7.00 | 183.00 | 190.00 |
1/10/2017 | Jan | 2017 | 13.00 | 187.00 | 200.00 |
2/2/2017 | Feb | 2017 | 12.00 | 198.00 | 210.00 |
2/3/2017 | Feb | 2017 | 15.00 | 205.00 | 220.00 |
2/4/2017 | Feb | 2017 | 17.00 | 93.00 | 110.00 |
2/5/2017 | Feb | 2017 | 13.00 | 106.00 | 119.00 |
2/6/2017 | Feb | 2017 | 12.00 | 118.00 | 130.00 |
2/7/2017 | Feb | 2017 | 9.00 | 130.00 | 139.00 |
2/8/2017 | Feb | 2017 | 5.00 | 141.00 | 146.00 |
3/3/2017 | Mar | 2017 | 6.00 | 152.00 | 158.00 |
3/4/2017 | Mar | 2017 | 8.00 | 164.00 | 172.00 |
3/5/2017 | Mar | 2017 | 4.00 | 176.00 | 180.00 |
3/6/2017 | Mar | 2017 | 7.00 | 183.00 | 190.00 |
3/7/2017 | Mar | 2017 | 9.00 | 187.00 | 196.00 |
4/5/2017 | Apr | 2017 | 10.00 | 198.00 | 208.00 |
4/6/2017 | Apr | 2017 | 13.00 | 205.00 | 218.00 |
4/7/2017 | Apr | 2017 | 15.00 | 93.00 | 108.00 |
4/8/2017 | Apr | 2017 | 12.00 | 106.00 | 118.00 |
4/9/2017 | Apr | 2017 | 14.00 | 118.00 | 132.00 |
4/10/2017 | Apr | 2017 | 10.00 | 130.00 | 140.00 |
5/6/2017 | May | 2017 | 8.00 | 141.00 | 149.00 |
5/7/2017 | May | 2017 | 7.00 | 152.00 | 159.00 |
5/8/2017 | May | 2017 | 10.00 | 164.00 | 174.00 |
5/9/2017 | May | 2017 | 6.00 | 176.00 | 182.00 |
5/10/2017 | May | 2017 | 9.00 | 183.00 | 192.00 |
5/11/2017 | May | 2017 | 10.00 | 187.00 | 197.00 |
5/12/2017 | May | 2017 | 14.00 | 198.00 | 212.00 |
5/13/2017 | May | 2017 | 15.00 | 205.00 | 220.00 |
