issue with percentage + issue with layout/subtotals

[illusionek]

Hello all!

I am very new to Cognos Report Studio, so perhaps solution to my issues will be very easy but I have been trying for the last few days and cannot solve them. I have following two (separate) problems.

1.

I use following function to obtain Outstanding Quantity:

if ([Sales Status] = '40')
then
([Sales Quantity])
else
('0')

Above function works well and all quantities displayed are correct. However I have an issue with obtaining % value. When I do [Outstanding Quantity/[Order Quantity], I do not get any figures for each line (just 0%) but the summary/overall figure is displayed and calculated properly. I was playing with total(), changing aggregation etc but nothing seems to be working.


2.

My other problem is with the layout of the report. I have around 15 columns in report (list) last couple columns has numerical values. Now I need to do subtotal for column 1, 4 and 7. So I group these columns and do summary. Everything is fine so far but my problem is that I need to repeat items in each line for columns 1, 4, 7. I discovered that I can group columns (to get subtotals) and still repeat items if I change settings of 'Group Span' but the problem is that then all subtotal names get aligned to first column. So I either need to get a better way of doing subtotals or change something in grouping option.

I basically need a layout I could get using PivotTable in Excel if I selected Repeat All Items option.


Thank you in advance for all your help!

[calson33]

for # 2, it sounds like you might want to use a crosstab report instead of a list which is the equivalent of a pivot in excel.