1. Home
  2. help
  3. How to Create a Pivot Grid Widget
  4. Assigning Data to the Pivot Grid Widget

Assigning Data to the Pivot Grid Widget

First, I need to drag the pivot grid widget from the “Relationship” section of the widget menu to my dashboard. Then, I am going to resize the widget by dragging its edges so that it will be easy to read.

I know that pivot grid widgets allow me to display data in multidimensional views for easy analysis.

In this widget, I would like to see the unit price of each product shipped by year so I can see how much money I earned yearly for each product.

To assign data to my widget, I need to click the “Settings” button in the upper right corner of the widget. Then, I will click the “Assign Data” tab.

I immediately see two columns. In the left column, I can select different fields called “Measures” and “Dimensions.” I can drag these fields to the “Value(s),” “Row(s),” and “Column(s)” boxes in the right column.

Pivot grid-Assign data

Now, I am going to drag “UnitPrice (Products)” to the “Value(s)” box, “ProductName” to the “Column(s)” box, and “ShippedDate” to the “Row(s)” box.

Pivot grid - value box

Pivot grid - Row box

Pivot grid - Column box

Was this article helpful to you? Yes No