Skip to Content
0
Former Member
Mar 20, 2009 at 05:00 PM

Subtotal within section

17 Views

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!