data

[Anonymous]

Hello

Attached is the sample attachement.

please let me know suggestions.

[markodonovan]

Hi John,

You should find this post by HIC useful

The As-Of Table

Thanks

Mark

http://techstuffybooks.com

[sunny_talwar]

Try the attached out:

Expression:

=Sum({<[AutoNumber(YrPd)] = {"$(='>=' & Min([AutoNumber(YrPd)]) & '<=' & (Min([AutoNumber(YrPd)])+ 12))"}, YrPd, Yr, Pd>}Value)

[Anonymous]

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.

[sunny_talwar]

Not sure I understand. what is 2015p16-13?

[Anonymous]

that is roll back of 13 months for previous year

[sunny_talwar · Accepted solution]

Something like this?

Blue is Max - 13,

Red is LY Max - 13

[Anonymous]

yes but can you write the expression here?

because i cannot open your attachment

[sunny_talwar]

Expression:

=Above(Sum({<[AutoNumber(YrPd)] = {"$(='>=' & Min([AutoNumber(YrPd)]) & '<=' & (Min([AutoNumber(YrPd)])+ 25))"}, YrPd, Yr, Pd>}Value), 13)