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
5706 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

How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)

4 Answers JKL, Kudos India,

first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 Answers

3. What was the size of your cube?

1 Answers IBM,

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

What is Star schema group?

1 Answers IBM,

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

0 Answers

-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?

1 Answers IBM,

-----------Diff b/w OLAP and RDBMS?

0 Answers Bank Of America,

what is loop in frameworkmanager ?

4 Answers Texas,

Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers

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

2 Answers

For more Cognos Interview Questions Click Here