Re: Add field from cyclic group in TOTAL expression
You can either use a dollar sign expansion using GetCurrentField() ...
... or just add all fields from the cyclic group to the TOTAL qualifier field list.
From the HELP:
Using the total qualifier inside your aggregation function disregards the dimensional value.
The aggregation will be performed on all possible field values.
The TOTAL qualifier may be followed by a list of one or more field names within angle brackets. These field names should be a subset of the chart dimension variables. In this case, the calculation is made disregarding all chart dimension variables except those listed, that is, one value is returned for each combination of field values in the listed dimension fields. Also, fields that are not currently a dimension in a chart may be included in the list. This may be useful in the case of group dimensions, where the dimension fields are not fixed. Listing all of the variables in the group causes the function to work when the drill-down level changes.