Hi Cristina,
It is important to know the scope in which each expression is evaluated, because the Fields!Some_Col reference cay actually return a different array of rows, depending on the scope.
For more information about scopes - see:
Pivot Engine > Pivot Processing
Pivot Engine > Variables > Fields
The easiest way to find out the scope is to save the state to file and see where this expression is written. The possible values are:
Pivot Scope - all properties of the chart areas, axes etc.
Row scope - for example the label property of a category is in row scope.
Col scope- for example the label property of a series is in row scope.
Data Cell scope - this includes the Value, Label, Tooltip prop/erty and properties related to Actions, Data Point appearance etc.
Expressions can also appear in Filters, Grouping and Sorting Rules but their scoping is not hierarchical - this is explained in these topics:
Pivot Engine > Grouping, Filtering and Sorting > Grouping
Pivot Engine > Grouping, Filtering and Sorting > Filtering
Pivot Engine > Grouping, Filtering and Sorting > Sorting
So back to your question - the =COUNT(Fields!Status) expression, if assigned to the ToolTip property, evaluates in a data cell scope.
To make the same value appear as a data label, you need to set the =COUNT(Fields!Status) expression as a Label of the data point (from the Values>General>Data>Label text box).
You also need to write this in the Values>Data Labels>Format text box: <label>
This assings a label string to each data point, which is equal to the count of records contained in the current scope (BTW you can also use Fields![RowCount]).
The data labels are formated to show that label. For more data label options see:
Chart > Data Model > Data Point Formatting Commands
Best Regards,
Nevron Support Team