How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAS

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.

Question Posted / mrutyunjay

3 Answers
8040 Views
Kudos India, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHE..

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

How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHE..

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

How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHE..

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

Post New Answer