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 / balanandam

By edit the expression we can avoid the C column

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the difference between ‘macros’ and ‘prompt’?

607


What are the main services provided by application tier?

571


What do you understand by ‘ibm predictive maintenance and quality’?

566


What is the complex report you faced in real time?

1735


how to explain health care project and which reports we can create in health care doain?

6358






I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

1626


what are the dimensions that you have in your current project?list them?

1602


How to select multiple values from type-in prompt?

646


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3919


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

1642


hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

1943


What are the advantages of shortcuts?

535


What are slice and dice?

532


What are all the types of gateway used in Cognos?

551


explain how to create powerplay reports?

612