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 |
-------------------What is StarShema?
What are the different types of important services used in cognos?
in u r data u having duplicates how to fetch the latest data in our report?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
data import to models, datastores,stored processed, is there any other way to import data?
can you apply grouping on crosstab?
Give me some examples for Lifecycle reporting,i mean which lifecycle we will use for reporting
How to crate cubes in transformer ?
I have the below IBM COGNOS 8 Certification latest Dumps: COG-112: IBM Cognos 8 BI Author COG-122: IBM Cognos 8 BI Administrator COG-125: IBM Cognos 8 BI Data Warehouse Developer COG-132: IBM Cognos 8 BI Metadata Model Developer COG-135: IBM Cognos 8 BI OLAP Developer COG-145: IBM Cognos 8 BI Multidimensional Author COG-180: IBM Cognos 8 BI Professional Recently new questions also have been updated in this Dump. If interested,mail me on kris.bi121@gmail.com with Exam Code and Exam name
what is textsource variable
-----------Diff b/w OLAP and RDBMS?
What are differences between Reporter report and Explorer report?