# Pivot Table, Dashboards

**Create a Pivot table to analyze the worksheet data**

A Pivot Table is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.

* Select the cells you want to create a PivotTable
* Select **Insert** > **PivotTable**.

![](https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwjfovZFMnfY6ZzPZb%2F-LRwkDKvXyVRfARZl2LX%2Fimage.png?alt=media\&token=f99836fe-ad1a-45f2-89ca-3ac5df7fab3b)

* &#x20;Under **Choose the data that you want to analyze**, select **Select a table or range**.

![](https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwjfovZFMnfY6ZzPZb%2F-LRwkSD_rasrGkrVUnJ5%2Fimage.png?alt=media\&token=cf8e1f71-30f9-4280-a3ff-03a027f67d6f)



* In **Table/Range**, verify the cell range.
* Under **Choose where you want the PivotTable report to be placed**, select **New worksheet** to place the PivotTable in a new worksheet or **Existing worksheet** and then select the location you want the PivotTable to appear.
* Select **OK**.



#### Building out your PivotTable

* To add a field to your PivotTable, select the field name checkbox in the **PivotTables Fields** pane.

![](https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwjfovZFMnfY6ZzPZb%2F-LRwkmgaeoTBjuuziY2y%2Fimage.png?alt=media\&token=a82049e5-c27e-4a2e-ac59-1fbbb26b04fe)



* &#x20;To move a field from one area to another, drag the field to the target area.



{% file src="https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwjfovZFMnfY6ZzPZb%2F-LRwl5tJ0fSVq0cpR30-%2Fpivot%20practice.xlsx?alt=media&token=6b66e60c-69f8-481a-b2cb-50637ce9e464" %}
Pivot Table Example1
{% endfile %}

{% file src="https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwjfovZFMnfY6ZzPZb%2F-LRwlAv2YKA4eqfR52av%2Fpivot_table_new.xlsx?alt=media&token=84d9900c-ef23-47aa-a1d9-79bda12b9f0b" %}
Pivot Table Example2
{% endfile %}



**Dashboards**

Dashboards give you unprecedented visibility into your work. You can get a quick, visual status update on your projects or drill down into important details, all in one place. Dashboards can boost your organization’s speed by allowing you and your team to see more, manage more, and communicate more.

**Refer the attached example sheet for Dashboard**

{% file src="https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRwjfovZFMnfY6ZzPZb%2F-LRwlwdFZx-u43GjwwLK%2FDashboard.xlsx?alt=media&token=04f7b789-c99a-4e30-ab96-3834b1a0ca8b" %}
Dashboard Example
{% endfile %}

