COGNOiSe.com - The IBM Cognos Community

I have created the following discontinuous crosstab (using the GO DataWarehouse of v8.3):

                                                                   <#Year#>           <#Order Method#>

<#Product line#>     |  <#Revenue            <#1234#>                  <#1234#>
                                 |  <#Quantity#>       <#1234#>                  <#1234#>
<#Product line#>     |  <#Revenue            <#1234#>                  <#1234#>
                                 |  <#Quantity#>       <#1234#>                  <#1234#>

When I try to add a Total Revenue line via a Query Calculation as follows:

                                                                   <#Year#>           <#Order Method#>

<#Product line#>     |  <#Revenue            <#1234#>                  <#1234#>
                                 |  <#Quantity#>       <#1234#>                  <#1234#>
<#Product line#>     |  <#Revenue            <#1234#>                  <#1234#>
                                 |  <#Quantity#>       <#1234#>                  <#1234#>
________________________________________________________________ insertable object (Query Calculation) inserted here across all data items and measures.  I want to create a subtotal for Revenue

When I try to validate the calculation (total([Revenue])) , I get the following error:

QE-DEF-0459 CCLException
QFS-ERR-0140 The referenced data item 'Revenue7' is not found in the query 'Query1_tab0_sub'
RSV-VAL-0044 The member caption can only be used in the scope of crosstab or chart

If I make the crosstab continuous by removing either the year or the order method, this approach works, yet it fails when the crosstab is discontinuous (i.e. has both year and order method)

Ultimately, I want to have two (2) subtotal lines, one for revenue and one for quantity, but for now, I can't get even one to work.

Any ideas on how to accomplish this task?

Thanks in advance.