I have a Report based on a Crosstab Query.
Rows : Date - value for A - Value for B - Value for C
Totals for the columns A-B-C were created automatically.
I also want to have the Total for (A+B+C). When I create a field in the detail section (ValueA+ValueB+ValueC) , this total is only shown on the report when all the columns for that date have a value.
So, when e.g. Value B is blank, the total is not shown.
How can I solve this ?
I added an example in attachment. In blue are the Totals I added.
Rows : Date - value for A - Value for B - Value for C
Totals for the columns A-B-C were created automatically.
I also want to have the Total for (A+B+C). When I create a field in the detail section (ValueA+ValueB+ValueC) , this total is only shown on the report when all the columns for that date have a value.
So, when e.g. Value B is blank, the total is not shown.
How can I solve this ?
I added an example in attachment. In blue are the Totals I added.
Attachments
Last edited: