Interested to Buy Any Domain ? << Click Here >> for more details...
How to findout YEAR CALCULATION?
THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE.
WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY
THIS YEAR RESULT AND LAST YEAR RESULT.
- 3 Answers
- 7967 Views
- Kudos India, I also Faced
- E-Mail Answers
Answer Posted / nasa
scenario:
Display 2013 and 2014 revenue and compare that country wise?
report studio-> list-> drag and drop a country data item
from branch query subject
drag a QUERY CAL from tool box drop beside country column
Name: 2013_revenue
expression:
if(order_year=2013) then(sales.revenue)
else(0)
drag a QUERY CAL from tool box drop beside 2013_revenue
column
Name: 2014_revenue
expression:
if(order_year=2014) then(sales.revenue)
else(0)
drag a QUERY CAL from tool box drop beside 2014_revenue
column
Name: variance_between_2013 and 2014
expression:
2014_variance - 2013_variance
ok
save and run
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of studio present in Cognos?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is a Datastore in Cognos?
------------------What is Inline Query?
explain how to create powerplay reports?
Why cognos scenario is used?
What are the advantages of using cognos sql?
What is catalog and types of catalogs in cagonos and which is better?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
Can you define slice?
What is the difference between regular dimension and derminant?
Define olap designer?
What do you mean by Drill down and Drill Up?
What is the difference between drill through, drill across?
How to select multiple values from type-in prompt?
