To get rid of the blank column, you need a filter. Unfortunately, if you add a filter, it would also apply to the first portion of your viz - 2015 vs 2016. Filters act on entire sheets - they don't have finer granularity.
The only way that I'm aware of is to separate the 2 portions of your viz to different sheets, and then combine them in a dashboard. That way you'll be able to define the filter only on the portion you need.
Similar issues were discussed in the following posts:
Hope this helps! Let us know if you have more questions.
Thanks for the links! I'll take a look and then get back to you!
Hi Kyle - this is how you can do it:
1. Duplicate the sheet you produced. (Right-click on it, choose Duplicate)
2. Remove the YoY Sales% from Sheet1, and AGG(LY vs TY Sales) from Sheet 2 (so you can isolate the 2 tables you want to filter differently)
3. In Sheet 2, create a calculated value with definition LAST()=0. This will allow you to filter out all columns in the table except the last one.
4. Drag LastColumn to filters, choose True. The blank column disappears, the relevant column is unchanged.
5. Create a dashboard where you would bring the 2 sheets together. Click on Floating so you have full control on how to position and resize the sheets you move here.
6. Drag Sheet 1 and Sheet 2 to the dashboard, resize and format them as you wish.
I'm attaching what I produced. Hope it helps!
1 of 1 people found this helpful
Hmm. Yes, you are right. You didn't have Totals in your original workbook, so I didn't see it.
Not sure why this is happening, but you can still work around - you can overlay sheet 1 over sheet 2 in your dashboard, so it hides the blank column. Just make sure you choose "bring to front" for Sheet 1. Take a look at the attached.
Looks like that's the only remedy, thanks man I appreciate your help and time!