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
- 6804 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 difference between querystudio in reportnet and cognos8
How to create a cube in Transformer? What is the process? Please mention process thank u
is there any difference between operational database and data base?if yes what r they?
faq's on cognos
What r the names of the reports that you prepared?
how to perform back drill through in cognos 8 what is the use of it
What is a dimension?
What is drill down and slicing and dicing whats the difference between them?
How can we Maintain the Cube Security by Category level and Dimension level ?
Why need staging area database for dwh?
What is the advantage of using shortcuts?
----------------------What are the User Securities?
Can you define metrics designer?
Write various indexes used in cognos?
What is the difference between group and associare?
