If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to subtotal multiple measures in a discontinuous crosstab

Started by plaintext, 07 Aug 2008 03:41:58 PM

Previous topic - Next topic

plaintext

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.