Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have data for 4 months(Jan to Apr)
I want to create an expression that show if Apr-2012 percentage is greater than Jan-2012. If there is no data available in Jan then take feb and so on.
eg- For Product Sub-Category- 'Office Furnishings' there is no Jan data, so pick the Feb. Similarly 'Bookcases' don't have Apr data, so pick March data.
Please help!
Why not these?
Hi Suraj,
Q1) What if you have Data for Jan,Feb and April but not for March?
For Jan you want to look forward and for April you want to look backward what about the months in the middle?
Amazing question ... I was wondering the same thing
sorry, i myself not clear with the requiremen.
I Actually want to check percentage increase or decrease between each month-year.
so between each month i want to show GREEN color when current month is more than previous, otherwise show red color in a new column.
Thanks!