If I am understanding you properly, you need to remove dates from the view, but they still need to be available to your Computations. You can do this by turning your Date dimension into a Table Calculation. Because Table Calcs are evaluated after all the values are pulled into Tableau, this allows us to effectively "hide" dates while still being able to use them in calculations. We typically do this by creating a Table Calc on our date dimension, such as:
Then, we place the regular discrete dimension pill for Date on the Detail shelf, and set the Compute Using on the Table Calc to be on the date dimension.
The basics of this idea are also shown here, although this one does not include Dates (but its the same concept/idea in practice): A Jedi (Filter and Table Calc) Trick | Tableau Software
Also, if you have trouble following any of the above, post a sample TWBX using the Superstore Sales dataset that ships with Tableau, and I'll be happy to try and provide my solution on that workbook. Cheers
That works perfectly, thanks a lot!
No problem; this comes up a LOT and there are a lot of useful scenarios for wrapping a dimension in a Table Calc like this. Cheers