Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this in a pivot table? May be use Before() function...
Hi Sunny
It does not work
n short the requirements is
Current-Previous and display arrow in current cell
Thanks
I need as below
Thanks Sunny