Create a blank table in Power Pivot

In Power Pivot, you can add a blank table to the Data Model. Blank tables that don't contain data can be a useful way to organize measures, making them easier to find in PivotTable field lists. For example, you can create a table named Sales Measures that contains only measures that calculate sales data. You can create measures in the Sales Measures table's calculation area just as you would in any other table. You can then hide the blank column from client tools, exposing only the measures in the PivotTable Fields list.

Add a blank table to the data model

1. In Excel, right-click an empty cell in an existing or new worksheet, and then select Copy.
2. On the Power Pivot tab, select Manage to open the Power Pivot window.
3. In the Power Pivot window, select Paste or press Ctrl+V to open the Paste Preview dialog box.
4. In Paste Preview, in the Table Name box, enter a table name.
5. Leave Use first row as column headers selected, and then select OK.

You now have a new table with a single blank column. To hide the blank column, right-click the column header, and then select Hide from Client Tools. You can also delete the blank Excel worksheet that you copied the empty cell from.