Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
chart how to shows wiil be privieous year and cureent selection year wise sales, when am i select year listbox
ex : year=2012
the chart shows 2011,2012 year wis sales
load * Inline [
year,sales
2011,1254
2012,1225
2013,12545
2014,00222
];
hi
Try like this
Year as Dimension
exp: =Sum({<year ={">=$(=Max(year)-1)<=$(=Max(year))"}>}sales)
Hi Ram,
Create two expression in a bar chart.
1. Sum({<Year={'$(=GetCurrentSelections(Year))'}>}Sales)
2.Sum({<Year={'$(=GetCurrentSelections(Year)-1)'}>}Sales)
Regards
KC
Hi,
=sum({<year={'>$(=max(year_selected)-(1)) <=$(=max(year_selected)-(current_year))'}>}sales)
try with these exp..,
CY
=num(sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} LineSalesAmount), '$#,##0;($#,##0)')
PY
=num(sum({$<Year = {$(=only(Year) - 1)}, Month = {"<=$(=max(Month))"}>} LineSalesAmount), '$#,##0;($#,##0)')