If I'm understanding your question properly, I think that you want to hide the 2016 data. (Right-click on the 2016 header, and select Hide).
As you probably noticed, if you filter (or exclude) the data, the blank year just moves up. Table calculations calculate based on the data in the view , so if you filter out a year, it's not in the view. However, hidden data is still in the view. Also, if you ever want to see that data again, you can right-click on another header, and click Show hidden data.
Hope that helps!
Thank you Sandlin, but I'm looking for something more complex it seems as I don't want to filter the year from the dollars view, just the empty column for the YoY %
unfortunately I am unable to share the data, but may be if I explain what the data is it might help.
I have over 5M transactions, each rolling up to different levels of detail, I really would like to have the dollar totals for years 2016, 2017 and 2018 shown on the first half of the table. On the second half of the table I'd like to show the YoY change/growth however, since 2016 doesn't have a reference year (no 2015 data) it shows up empty, I want to remove that empty column from the view WITHOUT removing the 2016 dollars data. Hiding the column on the YoY side also hides it from the dollars side.
I hope this helps, I have been really trying to solve this on my own and searching everywhere.