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

Answers were Sorted based on User's Feedback



Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B..

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

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B..

Answer / balanandam

By edit the expression we can avoid the C column

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

how to create calculate column in report studio

4 Answers  


write a query to display the departments with no employee?

0 Answers   HCL,


what is model and how to create model and how to test model?

8 Answers   IBM,


Why Star Schema is de-normalized? Please explain in detail probably with some examples.

2 Answers   DELL,


Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

0 Answers  






how can we improve performance of the reports?

6 Answers  


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

0 Answers  


What is difference between page break and section report?

0 Answers  


Is there any comparison available for Cognos Reportnet Vs Crystal reports?

0 Answers   IBM,


What is meant by report studio short cut?

2 Answers  


Can you define a query subject?

0 Answers  


is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 Answers  


Categories