Good Afternoon Everyone -
I have a question about report design, which is seemingly very simple but I cannot seem to figure it out.
I basically have a a report that contains 2 variables. for example, lets call them [list] and [numbers]
I put the report in section format, where the section is [list] and there are corresponding [numbers] within that list.
Lets say that we have the setup of the report as follows:
List1
1
2
3
4
5
What I want to do is have a variable added within [numbers] that will combine 1+2, but also keep them independent. Therefore the NEW list would display as follows:
List1
1
2
1+2 Subtotal
3
4
5
I tried if statements, but this then combines 1 and 2 and removes them from the report entirely. Im not sure if this can be done as the [numbers] dimension just contains a list of these numbers.
Please help!