Handling Additional Annoyances

You've reached the end of the adjustments that you can make to the pivot table. To achieve the final report, you have to make the remaining adjustments after converting the pivot table from a pivot table to regular data.

Figure 12.16 shows the pivot table with all of the adjustments described in the previous sections made and with PT.TableRange2 selected.

Figure 12.16

It took less than 1 second and 30 lines of code to get 90% of the way to the final report.To solve the last five annoying problems,you have to change this data from a pivot table to regular data.

0 0

Post a comment