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.
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.