Create Pivot Widget
1. Click on hamburger icon.
2. Click on (+) icon, from dashboard tab.
3. The Create Dashboard Dialog box will pop up on screen. Enter Dashboard Name as shown in Figure.
4. Click on Create After entering Dashboard Name in dialog box.
5. You will see an Empty Dashboard, As shown in figure below:
6. From Right Vertical Menu Select the Pivot Widget icon.
7. The Edit menu box appears as you click on Pivot chart icon. And a widget gets added in content place automatically in dashboard, As shown in Figure below:
8. Enter Following details in chart controls:
Name: Product Count Data
Type: Table
Dataset: Product Details.cds
9. Drag and drop country in rows and Product Line in Columns.
10. In value click on Setting Icon on Total and enter Following Details.
Name: Total
Display Name: Total
Type: Sum
Column1: extendedPrice
11. Fill above details in edit box, As Shown in figure;
12. Click on Preview and Save and Exit.
13. Now, match your Pivot with the below example, it should look like the figure below: