Thanks for the help I really appreciate it. As much as that displays the Projected amount. I want the 2014 year to show as 2014 YTD and 2014 PROJ. your formula displays only 2014 PROJ amount. However, I know there is a calculated field function in PIVOT TABLE, can this be used cos I don't have a clue as to how to get around using it.


Any and all help appreciated.

Thanks