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
- 7825 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
Why is auto-regression used in forecasting used on cognos platform?
What are slice and dice?
Which studio is used to create reports?
What are the main services provided by application tier?
What are all the types of hierarchies?
What are all types of Batches?
What are the ways to import data into catalog?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
Can you define framework manager?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What is the difference between the content store and content manager?
What are the different types of reports present in cognos?
Can you define set to be cardinality?
What is the size of database for you project?
Can you define drill across?
