reportserver-118938-create-dashboards-create-a-calculated-field.md
This tutorial demonstrates how to create a field that is not stored in the bound data source and is calculated using a pre-defined expression. For example, you can use data fields containing information about a price and quantity to evaluate a total price as well.
Do the following to create a calculated field:
Click the menu button and select Data Sources.
Select a required data source, select a query and click the Add Calculated Field button.
In the invoked Create Calculated Field dialog, specify the field Name and make sure to change the Field Type option to an appropriate value. Then, specify an expression for evaluating values of a calculated field.
Click Save to create a calculated field and display it in the data source structure with the f glyph.
You can use the calculated field as an ordinary field for binding dashboard items.
Open the grid item’s Bindings menu, click the Add Column placeholder and select the created calculated field.
Apply a currency format to this column and perform required data shaping operations. See Add Dashboard Items and Perform Basic Data Shaping to learn more.
See Also