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.