Tutorials Reporting ServicesGauges can show not only item data but they can also be used to show aggregates such as SUM, Average and so on. In this section, you will be creating another display type of a gauge and associating the average value of a column.
1. Right-click the data cell of second column (second column, second row).
2. Choose from the drop-down menu Insert Row | Outside Group Below.
3. Right-click the inserted textbox to access the properties of the Tablix as shown and click on Outside Group Below.
This adds a textbox outside the group for the second column as shown in the following screenshot:
4. Right-click the inserted textbox and click on Expression...;.
5. At the top, in the Set expression pane type in ="Avg= " &.
6. Expand the category Common Functions. Click on Aggregate to expand. In the Item field double-click Avg.
7. The Set expression for: Value gets filed with "="Avg= "& Avg (".
8. Now click on Fields (DataSet1) and in the Values: field double-click Second_.
9. The expression now becomes "="Avg= " & Avg(Fields!Second_.Value". 10 Close the parentheses to make the expression complete as shown:
="Avg= " & Avg (Fields!Second_.Value)
11. The textbox you created now gets this expression.
12. Click Home | Run to run the report. It is displayed as shown in the following screenshot, on the second page of the report.
