I'm having a table with months set as 1, 2, 3 , ...12 (String)
I'm trying to get the YTD value with the follow formula:
IF [Month] <= [Month Selection] THEN [Sales]
(Month selection being a parameter, set as String)
However the system will includes 10, 11 and 12. (as it is still "inferior" to current monh, 6...)
Any idea how to fix this?
Just replace the parameter.
Let me know If you've any query.
This did the trick !
Thank you !
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...