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 |
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
How to select all in value prompt instead of cascade prompt?
what is a Galaxy Schema?
How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
how to perform single sign in cognos by using url?
What are the types of studio present in Cognos?
how data modeling is usefull to cognos?
what is the difference between querystudio in reportnet and cognos8
we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333