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
- 7883 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 is the function of cognos dispatcher?
What is meant by Reportstudio shortcut?
What is main difference mapplets and mapping?
What do you understand by the term 'model durability'?
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 are various types of gateways in cognos?
What are the types of security?
difference between impromptu and cognos8
New coloums are added in database, then how you know in report level
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is the difference between static and dynamic conditions?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is cognos reporting tool?
Explain the different types of views used in cognos.
What is a Query Subject?
