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 |
Define cognos report net?
---------------How to identify First Record and Last Record?
what is the difference between filter and condition?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What is the difference between static and dynamic conditions?
----------------What is Surrogate Key?
Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?
What is the diff between Drill through reports and Master detail reports?
how to explain health care project and which reports we can create in health care doain?
What are all the types of hierarchies?
how to do page breaks in cognos 8 Report studio pls give the navigation