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 / 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 |
Post New Answer View All Answers
what is online view?
What is the difference between Open Connection command ang Open Session Command?
how to test reports in cognos?
What are the different types of reports present in cognos?
-----------Diff b/w OLAP and RDBMS?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is cognos connection?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What is difference between data mart and data warehouse?
What is a Cube?
what is a prompt value in report studio and variables ?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
How can create users and permissions in cognos?
What is Fullouterjoin?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.