Why is the data structure non-negotiable? Your BI team should be able to easily reformat this so that actual and projected are separate columns (or you could do it yourself with Custom SQL). Someone may be able to get you the result you're looking for with your current format, but I believe it would be much simpler with separate columns (measures).
Sorry I'm not much help otherwise. Can you post a packaged workbook file that demonstrates this problem? You can use the sample Superstore data to do so.