Drag it to Filter and Set TRUE
I've already tried a method similar to this.
I used [Ship Date] < TODAY() and set it to True. But then the entire 2019 column disappears.
I don't want the column to disappear I just want the "Sales" bar in that column to read 0.
1 of 1 people found this helpful
IF Year(Ship Date)<=Year(Today()) THEN Sales Else 0 END
Replace your Sales on Label with This.
Oh my gosh. The bar is gone, That solved it!
Thank you so much!
Great!!! Please Take a sec to Close The Thread by marking my Reply as CORRECT, The CORRECT button is under my reply in your main thread, not in email