I want to total the values in the far right column - Net New Clients - in this sub summary report.
c_NetNewClient is a calc field with the calculation shown below.
GetSummary(s_TotalNbrOrders;Edition) - GetSummary(s_TotalNbrCancellations;Edition)
I am sorting on Edition and the results in the sub summary part are correct. But I have not been able to total their results in the Trailing Grand Summary part. The field, s_NetNewClients (summary, total of c_NetNewClient) does not work.
What am I doing wrong here?