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
Explain what is the difference between native sql and cognos sql?
Can you define metrics designer?
What are the steps to import the two data sources in framework manager?
How create measures and demensions?
What is main advantage datawarehousing over oracle?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
what are the dimensions that you have in your current project?list them?
What is the difference between a data mart and a data warehouse?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Can you define cube?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
what is the role of cognos comsultant?what actually it means?pls reply
What is the difference between static and dynamic conditions?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?