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
- 7972 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 to create relationship between emp and salgrade tables in frameworkmanager?
how to get the all values from a prompt using 'ALL' use and display value in prompt
How to join multiple db in catalog?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
Can you define cognos powerplay?
What do you mean by drill across?
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?
-------------How to do Bursting a Report?
What is an open session command in cognos connection?what is it meant for?
what is the main advantage of impromptu over cognos reportnet?
Can you define cognos decision stream?
What is the metric store database?
Teradata 
