Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
bar chart sum last year total
sum( {$<Year={"<=$(Year)-1"}>} value)
Dimensions : if(MonthYear >= '012013',MonthYear)
bar chart value :
012013 > 60
022013 > 60
032013 > 60
042013 > 60
052013 > 60
062013 > 60
072013 > 60
082013 > 60
092013 > 60
102013 > 60
112013 > 60
122013 > 60
try
SUM({<Year = {'$(=max(Year)-1)'}>}value)
Regards
Al
or you could try
Hi Alan,
expression you sent ; SUM({<Year = {'$(=max(Year)-1)'}>}value)
should be ;
Hi Alan,
expression you sent ; SUM({<Year = {'$(=max(Year)-1)'}>}value)
should be ;
so should it be
SUM({<Year = {'$(=max(Year))'}>}value)
which will give
should be ;
I want to be like
example : 012013 value >> 2012 vales total 60
012013 > 60
022013 > 60
032013 > 60
042013 > 60
052013 > 60
062013 > 60
072013 > 60
082013 > 60
092013 > 60
102013 > 60
112013 > 60
122013 > 60
so add TOTAL, something like
Thanks Alan,
There is a more problem with,
Year to day total
how can ?
example : bar chart Dimensions >> montyear 08-2013
< 08-2013 + > 01-2013
value YTD total > 80+70+60+50+40+30+20+10 = 360
example : bar chart Dimensions >> montyear 07-2013
value YTD total > 70+60+50+40+30+20+10 = 280
Hi,
See below, maybe this could get the result you need