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
Answer Posted / balanandam
By edit the expression we can avoid the C column
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define catalog in cognos and write its various types?
What is a Datastore in Cognos?
-----------With out using DrillThrough how to do Reports?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What are the types of studio?
Can you define a catalog and types of catalogs in cognos?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
what is the role of cognos comsultant?what actually it means?pls reply
Can you define metrics designer?
Can you explain dynamic query mode?
What is the difference between regular dimension and derminant?
What are initial page components of Cognos connection?
What is the report studio?
What is the function of model design accelerator?
Explain difference between powerplay transformer and power play reports?