Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Attached is the sample attachement.
please let me know suggestions.
Try the attached out:
Expression:
=Sum({<[AutoNumber(YrPd)] = {"$(='>=' & Min([AutoNumber(YrPd)]) & '<=' & (Min([AutoNumber(YrPd)])+ 12))"}, YrPd, Yr, Pd>}Value)
Thanks SUnny
this works fine but i need one more bar which shows the previous year 13 months roll back data
i.e one bar shows 2015p16 -13 and the other bar shows 2014p16-13
could you please let me know that expression.
Not sure I understand. what is 2015p16-13?
that is roll back of 13 months for previous year
Something like this?
Blue is Max - 13,
Red is LY Max - 13
yes but can you write the expression here?
because i cannot open your attachment
Expression:
=Above(Sum({<[AutoNumber(YrPd)] = {"$(='>=' & Min([AutoNumber(YrPd)]) & '<=' & (Min([AutoNumber(YrPd)])+ 25))"}, YrPd, Yr, Pd>}Value), 13)