Adding a Worksheet and PivotTable in Billing Analytics

When you have completed a worksheet as desired in Billing Analytics and would like to create a new worksheet to add to your workbook, you have two options. 

First, you can copy your current worksheet. This option is best if there are certain settings or fields that you would like to carry over, to save time when creating your new PivotTable. To do this, take the following steps:

  1. Right-click the name of your worksheet at the bottom of the screen and select Move or Copy:


  2. In the window that opens, select (move to end) and Create a Copy:


  3. Double-click the name of the new worksheet to rename as desired, and modify the new worksheet and PivotTable as needed:


If instead you would like to start with a brand new worksheet and PivotTable, you can take the following steps:

  1. At the bottom of the screen, click the icon to add a new worksheet:


  2. If desired, double-click the name of the new worksheet to rename.

  3. Click the top left cell in the worksheet, if it's not already selected:

     
  4. At the top of the screen, select Insert, then PivotTable:


  5.  On the resulting window, click Use an external data source, and click Choose Connection:


  6. Select your Connection, hit OK, and hit OK again:


  7. Add fields to your new PivotTable as desired.