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
- 7965 Views
- Kudos India, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pooja
Why do we need to do that? i mean why do we need to display
revenue of 2 years, when we are choosing a particular year
to display the value? What is the scenario?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / uzval_vee
by using expressions, i mean by using conditional
constructs and thru graphs we can view the revenue and
caliculated data as well.
| Is This Answer Correct ? | 0 Yes | 1 No |
How do we create row level security in cognos8?
What is Crossproduct?
can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.
-----------With out using DrillThrough how to do Reports?
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
How can we create regular dimensions & measure dimensions?
How can I schedule reports in cognos?
plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?
Can you explain cognos planning?
how to get the all values from a prompt using 'ALL' use and display value in prompt
Name the types of gateway?
Teradata 
