Previous month value does not evaluating

[Anonymous]

Hi All

I have report as under

  MY      Sep-2016    Oct-2016     Nov-2016

Score

S1             3                 5                  2

S2             5                 3                  3

The requirement is

  MY      Sep-2016    Oct-2016     Nov-2016

Score

S1             3                 Up                  Dn

S2             5                 Dn                  NC

I have used           

if(max(RAG) -
Max({$<MY={$(=chr(39) & date(AddMonths(MY, -1), 'MMM-YYYY') & chr(39))}>} RAG) > 0, '▲',
if(max(RAG) -
max({$<My={$(=chr(39) & date(AddMonths(MY, -1), 'MMM-YYYY') & chr(39))}>} RAG) < 0, '▼'
, ''))

Please advise

Thanks

[sunny_talwar]

Is this in a pivot table? May be use Before() function...

[Anonymous]

Hi Sunny

It does not work

n short the requirements is

Current-Previous and display arrow in current cell

Thanks

[Anonymous]

I need as below

Thanks Sunny