Text objects are a good way of displaying labels and expressions. Text objects can be made interactive by specifying Actions in the properties. Since we are working on a
Dashboard sheet, we will create text objects to display summarized information. We will create text objects for number of Orders, number of Customers, and Total Sales:
Dashboardsheet. Select New Sheet Object and then the text object.
Orders. Remember to put
=in front of the expression. If you are displaying labels then you don't need
='# Orders ' & chr(10) & Num(count(distinct OrderID),'#,##0') Distinct ...