Print Page - How can we achieve this report

Title: How can we achieve this report
Post by: EArumugam on 24 Mar 2011 12:35:25 AM

hi all,,

how to create the report as below. prod type , subtype and sales come from same table.
but i want to split A & B into one and make subtotal and C as seperate

Prod Type    | Sub Type | Sales
A     A1     10
     A2 20
     A3     30
TOTAL A     60
B     B1     5
     B2 4
     B3 3
TOTAL B        12

Net Sales(A+B)     72

C     c1     1
     c2     2
     c3     3
Total C        6

Gross Sales (Net Sales(A+B)-Total C)   66

please let me know if the question is not clear

Title: Re: How can we achieve this report
Post by: MFGF on 24 Mar 2011 12:32:51 PM

Try adding a calculation in a list column along the lines of:

if([Prod Type] in ('A', 'B')) then ('A+B') else ('C')

Group on this list column first, and you should get a result resembling your requirement.

Regards,

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: EArumugam on 24 Mar 2011 12:35:25 AM