1 Reply Latest reply on Jul 15, 2014 4:22 AM by Tom W

    Joining to a date dim

    . Nimesh82

      Hello,

       

      I have a quick question, I have a date dim which contains fields like last 5 business day, last business day etc. I was able to join to the date dim but now i need to create a report which shows the sales which happened on the last business day, last 5 business day and today. how can I achieve that.

       

      Just to give a brief background, the last 5 business day, last business day etc. are calculated in the backend based on a particular flag, thus I cannot use Tableau to calculate the last business day or the last 5 business day.

       

      Thanks,

       

      Nimesh