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
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 |
Answer / balanandam
By edit the expression we can avoid the C column
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos
What do you understand by the term 'model durability'?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What is stitched Query?
What is defined as Cognos Impromptu?
hi friends pls forward impropmtu interview question
How many number of cubes can we create on a single model? How can we navigate between those cubes?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What is Online View?
How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.
Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated
what is a prompt value in report studio and variables ?