I have calculated the following Pivot Table:
| YearMonth | A | B | C | D | E | F |
| 2013-01 | 12.0% | 88.0% | 85.8% | 85.1% | 84.8% | 83.9% |
| 2013-02 | 7.7% | 92.3% | 91.2% | 89.1% | 87.6% | 86.3% |
| 2013-03 | 10.1% | 89.9% | 88.9% | 87.9% | 86.7% | 85.7% |
| 2013-04 | 9.9% | 90.1% | 88.9% | 87.7% | 87.3% | 86.4% |
| 2013-05 | 9.5% | 90.5% | 89.4% | 89.2% | 87.5% | 85.6% |
| 2013-06 | 11.3% | 88.7% | 87.2% | 85.6% | 84.7% | 79.3% |
| 2013-07 | 10.5% | 89.5% | 87.3% | 84.4% | 81.7% | 77.0% |
| 2013-08 | 6.1% | 93.9% | 92.9% | 91.8% | 90.6% | 89.4% |
| 2013-09 | 12.1% | 87.9% | 86.7% | 85.8% | 85.2% | 83.8% |
| 2013-10 | 13.4% | 86.6% | 85.9% | 85.5% | 84.3% | 83.9% |
| 2013-11 | 5.0% | 95.0% | 93.9% | 92.5% | 90.9% | 90.5% |
| 2013-12 | 13.8% | 86.2% | 84.4% | 81.2% | 79.6% | 77.5% |
| 2014-01 | 12.0% | 88.0% | 86.8% | 85.9% | 85.4% | 84.8% |
| 2014-02 | 6.1% | 93.9% | 92.9% | 91.8% | 90.6% | 89.4% |
| 2014-03 | 9.6% | 90.4% | 89.4% | 88.6% | 87.2% | 85.3% |
| 2014-04 | 5.6% | 94.4% | 93.8% | 92.7% | 91.4% | 89.8% |
| 2014-05 | 10.6% | 89.4% | 87.2% | 85.3% | 83.9% | 81.7% |
| 2014-06 | 10.8% | 89.2% | 87.1% | 84.2% | 81.6% | 78.9% |
| 2014-07 | 10.6% | 89.4% | 88.4% | 84.5% | 81.8% | 80.8% |
| 2014-08 | 12.1% | 87.9% | 86.7% | 85.8% | 85.2% | 83.8% |
| 2014-09 | 13.4% | 86.6% | 85.9% | 85.5% | 84.3% | 83.9% |
| 2014-10 | 5.0% | 95.0% | 93.9% | 92.5% | 90.9% | 90.5% |
| 2014-11 | 3.8% | 96.2% | 95.9% | 94.9% | 92.7% | 91.8% |
| 2014-12 | 5.6% | 94.4% | 93.8% | 92.7% | 91.4% | 82.5% |
| 2015-01 | 10.6% | 89.4% | 87.2% | 85.3% | 83.9% | 77.5% |
| 2015-02 | 10.8% | 89.2% | 87.1% | 84.2% | 81.6% | 86.5% |
| 2015-03 | 10.4% | 89.6% | 87.0% | 83.1% | 82.0% | 80.3% |
| 2015-04 | 5.7% | 94.3% | 92.4% | 91.1% | 89.4% | 88.0% |
| 2015-05 | 8.9% | 91.1% | 89.1% | 86.8% | 85.5% | 83.9% |
| 2015-06 | 7.6% | 92.4% | 90.6% | 88.8% | 87.8% | 85.8% |
| 2015-07 | 16.8% | 83.2% | 81.7% | 79.9% | 78.2% | 76.2% |
| 2015-08 | 15.5% | 84.5% | 79.8% | 75.0% | 70.4% | 66.1% |
| 2015-09 | 10.0% | 90.0% | 88.1% | 86.7% | 85.5% | 83.7% |
| 2015-10 | 14.8% | 85.2% | 81.1% | 79.5% | 77.3% | 75.5% |
| 2015-11 | 9.9% | 90.1% | 88.6% | 86.7% | 85.4% | |
| 2015-12 | 18.7% | 81.3% | 78.5% | 76.9% | | |
| 2016-01 | 9.1% | 90.9% | 89.5% | | | |
| 2016-02 | 8.1% | 91.9% | | | | |
| Total | 9.7% | 90.3% | 88.5% | 86.7% | 85.3% | 83.8% |
The A-F calculation has condition related to YearMonth,. This is a ongoing report, the C-E has some blanks at the most recent months due to the incomplete of data.
I want to add more total rows to the table base on Year. The table should be somthing like this:
| YearMonth | A | B | C | D | E | F |
| Total 2013 | 10.0% | 90.0% | 88.1% | 86.7% | 85.5% | 83.7% |
| Total 2014 | 14.8% | 85.2% | 81.1% | 79.5% | 77.3% | 75.5% |
| Total 2015 | 9.9% | 90.1% | 88.6% | 86.7% | | |
| Total | 9.7% | 90.3% | 88.5% | 86.7% | 85.3% | 83.8% |
For each column, if that year doesn't have complete data, I don't want the result displayed. Eg, Total 2016 is not showed, E-F's Total 2015 is blank.
I don't know if it is possible, or I can only create another Pivot table?
