Hi

I have Columns A, B, C, D, E in a Crosstab Report,

Cost Budget Column A Column B Column C Column D
Column E Total of A+B+D+ E
Product 1 100 200 300
400 500 1200
Product 2 500 300 400
500 800 2100


Column A Column B Column C Column D Column E is coming from
the Query Item: Category

I dont want to include C Column value in the Total Column
Column Chas to display in the Crosstab Report

how to achieve it
Any idea

Thanks
Sumith

Answer Posted / pavan kumar

Ur Question is not correct bcoz here 5 columns n values r 6
how to add 6th value.Once check it n correct that question.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is stitch query in reportnet?

627


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

720


What are the themes in a data warehouse?

590


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

594


What is zero-foot print?

598






We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2084


What is main difference mapplets and mapping?

571


my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

3516


What is the difference between group and associare?

595


Can we test the report other than manual testing?

1662


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1519


Can you define cognos impromptu?

630


Can you define fan trap?

755


What is the complex report you faced in real time?

1735


-----------------What is Determination Model?

1694