1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

Question Posted / guest

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

Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

5 Answers   TCS,

data import to models, datastores,stored processed, is there any other way to import data?

1 Answers   TCS,

What is Render Variable? where u can use?

3 Answers  

what is Cognos Visualizer and Cognos Scripting?

3 Answers  

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers   HCL, Wipro,




What is slowely changing dimensions?why we are used SCD?

2 Answers  

How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?

2 Answers   Wipro,

cognos is holap or molap or rolap

7 Answers   Cognizant,

What is IQD?What is contained in IQD?

3 Answers   ABC, IBM, Infosys,

how can i provide security to my reports in report studio?

3 Answers   TCS,

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

0 Answers   HCL,

What is conditional Formatting?

2 Answers   HCL,

For more Cognos Interview Questions Click Here
Categories