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

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

2 Answers
5627 Views
I also Faced
E-Mail Answers

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

What is difference between content store and content manager?

0 Answers

Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 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 condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

0 Answers

how u migrate reports to cognos 8 from previous versions

3 Answers TCS,

What is Clipboard? How to import XML file into Clipboard?

2 Answers CSC, HCL,

What is the difference between cognos 8.2 and cognos 8.3?

5 Answers

What do you mean by query studio?

0 Answers

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

0 Answers

------------- How to identify the Revenue Column in Report?

0 Answers

what is the difference between cascading prompt and drill-thru

4 Answers

how u publish the packages in framework manager

3 Answers TCS,

For more Cognos Interview Questions Click Here