What is the expected value for the Price Target for the current year?
There are many fields, sets, actions in this workbook and it appears it will take considerable time to become familiar with the workbook to assist here. Is it possible to share a view of the month/target issue in a crosstab? We are unable to explore the Join since the extract is a single data source based upon the left join.
This post was written a couple weeks ago. Have you made any headway with the workbook?
Thank you! I actually did find a fix for this. There were date values in one table for all 2018 dates, and no future dates in the other file. I created an if isnull formula to use the dates from the past revenue tables, but if the date is null, than use the table with future dates.