Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get sale of current year and last year in a single graph with two expression
i"m using this expresion
current year:=SUM({<FiscalYearName={'$(vCFY)' },Flag={'IFK'} >}_Revenue)/sum(([Total No of SALE]))
last year:
=SUM({<FiscalYearName={'$(vLFY)' },Flag={'IFK'} >}_Revenue)/sum(([Total No of Meal]))
If your variables are defined properly and FiscalYearName field data format are similar to variable output, it should work fine. Otherwise, try to post your sample qvw.
Please Refer Attachment of Document and prepare variable will definitely solve your problem.
Vikas
What exactly isn't working for you? Or are you just checking if this is the proper approach?
It is, but not 100%. Please consider:
Good luck,
Peter
Hi,
What is the definition of the variables? what is the format of Fiscal Year?
If your Fiscal Year is in this format then try like htis
vCFY = Max(FiscalYear)
vLFY= Max(FiscalYear) - 1
current year:=SUM({<FiscalYearName={'$(vCFY)' },Flag={'IFK'} >}_Revenue)/sum(([Total No of SALE]))
last year:=SUM({<FiscalYearName={'$(vLFY)' },Flag={'IFK'} >}_Revenue)/sum(([Total No of Meal]))
Regards,
Jagan.
Hi Yogita,
You need to Create the two separate expression to view the Comparison of the Current Year Vs :Last Year.
1st Expression is SUM({<FiscalYearName={'$(vCFY)' },Flag={'IFK'} >}_Revenue)/sum(([Total No of SALE]))
2nd Expression is SUM({<FiscalYearName={'$(vLFY)' },Flag={'IFK'} >}_Revenue)/sum(([Total No of Meal]))
& Your Dimension should be the concessionaire name.
vCFY & vLFY variables should be added in your application.
or you can show the growth also like what is the growth of Current Year Over the Last Year.
Hope this might helps you.
Regards,
Alok