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

Subtotal for Column with 2 levels

Started by joecog, 24 Mar 2011 01:36:48 AM

Previous topic - Next topic

joecog

Hi,

I had a crosstab where I need to calculate the Total Sales and Total Return  but when I run the report, the Total Sales and Total Return will show zero figure.


What I want :

                             Product A                  Product B             Total Sales   Total Return
                         Sales       Return       Sales      Return

Customer 1          100         20             530        50             630          70

Customer 2          150         10             410        20              550         30



Any idea so that I can get the figure shown?

Joe