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.
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 use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
What are the advantages of cognos?
How can we create regular dimensions & measure dimensions?
What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?
What is the difference between set functions and filter function in dimensional data?
What is difference between drill through and drill down?
How can we find out cardinality between two tables?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
what is report studiio and how to start it?
how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls
what is model and say about process how to create model and how to test model?