I am trying to make the YTD Actuals for TODAY()s month = 0 and every future month = 0 WITHOUT changing the data from the prior months.
The calculation I'm working on...
Hide YTD Actuals ---
IF [Month] < INT(MONTH(TODAY())) THEN [Actuals] ELSE 0 END (See below)
It sort of works, it hides the bars I want to hide, but then the "YTD actuals" change because I don't know how to put a SUM in my calculation without getting an error.
Whenever I add a SUM I get an error message
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...