This content has been marked as final. Show 5 replies
I have date column for 4 years and its respective sales.
Now my requirement is if my date column having values for entire year ie(till 31/12/2014)
then i need a extra row saying 2014 YTD , it should add all the values till Nov 31st 2014..
If i dont have values for the entire year then i need a row saying 2014 YTD ,it should add all the values till oct 31st 2014..
Please find the attached Screen shot of the requirement