Hello,
I'm trying to create a calculation that can pull the sales value of a specific contract for the previous month. This data will be referenced many other places, so it can't be a table calc.
I've attached sample data, the value I'm trying to calculate is "Prior Month Sales" from the example attached.
Has anyone done something like this before?
3 answers
Then the only option is to join the data to itself and use a date offset in the join by calculation:
Or a similar approach in Tableau Prep to obtain the actual values (not displayed Table Calc values) of which the output would then be real values to be used in other calc's in Desktop.
Best, Don
(Please, don't forget to click Select as Best or Upvote !)
