6 Replies Latest reply on May 3, 2016 2:20 AM by Ashish Chaudhari

# Last 5 day sales for current month excluding weekends/national holidays

Hello,

I need to calculate last 5 days sales for current month excluding weekends/national Holidays.

Suppose my current day is 17th may. I have a national holiday on 16th of May 2016. I need to show 9,10,11,12,13 sales because 14 & 15 are weekends and 16th is a national holiday.

Kindly help me out.

Regards,

Koushik.

• ###### 1. Re: Last 5 day sales for current month excluding weekends/national holidays
1 of 1 people found this helpful
• ###### 2. Re: Last 5 day sales for current month excluding weekends/national holidays

Hello shashank,

thank you for the quick response.

For suppose, if we have national holidays on 5,11,18,24 this month. which calculation suits me the best?

can yu help me out. I need just one calculated field so that I should apply above logic( everytime)

regards,

Koushik.

1 of 1 people found this helpful
• ###### 3. Re: Last 5 day sales for current month excluding weekends/national holidays

Hi Koushik,

Please find the attached file which contains the desired result. However I have created it based on the parameter since I don;t have any transaction data for this month/ today. You can replace the Date parameter with today function when you are implementing it in your data.

Please update the Holiday tables with date and name of holiday. You can see I have excluded the holiday. (I have only mentioned Dec-25 as a holiday in the table.)

I have also created the parameter which take how many days back do you want to go. Your question would be in parameter 7 I have put 7 as a input but you are able to see only 5 days. Its because you need to write a condition for holiday for the same. I have no idea how to write it.

But for now this would be a good solution to your problem. Experts in the tableau community may have different perspective to the problem. Experts please take it further from here.

Thanks and Regards,

Ashish Chaudhari

4 of 4 people found this helpful
• ###### 4. Re: Last 5 day sales for current month excluding weekends/national holidays

Thanks a ton ashish.

• ###### 5. Re: Last 5 day sales for current month excluding weekends/national holidays

Mark answer as correct if that has helped and solved your query so that others can refer to this thread.

• ###### 6. Re: Last 5 day sales for current month excluding weekends/national holidays

Hi Prashant Bagalore , please take a look at this. I think you will need this.