Connect a Second Dataset to Your Workbook
If you have not already done so, complete Step Five: Pivot Your Dataset Query Results.
The following steps show you how to create and add an additional dataset from within your workbook.
To connect a second dataset to your workbook:
-
Click the add
icon to open a new workbook visualization tab. -
Click Connect Dataset.
-
On the Select a dataset page, click New Dataset.
-
Select a record type for the dataset.
For the purposes of this tutorial, select the item record type.
-
In the Dataset Builder, add the quantity on hand and quantity back ordered fields from the item record type to the Data Grid.
-
Click Save.
-
In the Save Dataset As window, enter a name and description for the dataset, then click Save.
-
Click Apply to workbook.
Continue to Step Seven: Set up a Table View.