Articles Comments

Free Excel Dashboards » Dashboard, Excel Dashboard, Excel Dashboard Software » How to build Excel Dashboards – 4

How to build Excel Dashboards – 4

Previous Part Build Excel Dashboards – 3

We will Add Calculations and Formulas

Add Calculations
Since this is a raw extract of actual transactions, it may need to add additional calculations and columns to create useful metrics.

For e.g in our sample file, we have the “Unit Price” and “Quantity” columns. We will create calculation to derive the “Amount” column

Image

 

Right click on the Quantity Column, Navigate to Popup Menu

Create ‘ –>Create Calculation
It shows a calculation wizard.
Image

1. Click on “Unit Price”
2. Click on * multiplication operator
3. Click on Quantity
4. Rename the column to “Amount”
5. Click on “Use this Formula”

As you see, the “Amount” column is added right next to the Quantity column

Image

 

Next – Add Date Hierarchy Columns Excel Dashboards – 5

For more information visit How to build Excel Dashboards – 4

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software

Comments are closed.