-
1. Re: MTD and QTD Filter
Shinichiro MurakamiJul 12, 2018 4:26 PM (in response to Tony Smith)
HI Tony
If you define fiscal week, which day of week is the start of fiscal week?
When is the start DATE of fiscal quarter?
When is the start DATE of fiscal year?
According to that, the first and last week is might not be 7 days.
Please confirm, or give us fiscal calendar table or clear definitions.
Shin
-
2. Re: MTD and QTD Filter
Tony Smith Jul 13, 2018 1:19 PM (in response to Shinichiro Murakami)Hi Shin,
Thank you for replying to my query. The fiscal date starts on the 1st of March each year. As required, I have also attached the calendar table to this message.
Thanks
Regards
Tony
-
BBAC CALENDAR 1.xlsx 104.7 KB
-
-
3. Re: MTD and QTD Filter
Shinichiro MurakamiJul 16, 2018 4:08 PM (in response to Tony Smith)
HI Tony,
Not exactly sure, but hope this helps.
Below two can specify the full week.
To make logic easier, add fiscal dates. to adjust April (4) to Jan (1) based on Fiscal year.
Month filter and Quarter filters.
Thanks,
Shin
-
4. Re: MTD and QTD Filter
Tony Smith Jul 17, 2018 11:17 PM (in response to Shinichiro Murakami)Hi Shin,
Thank you for all your help. I got an error message when I tried to open the attached file. Can you please reattach the twbx package again?
Thanks
Regards
Tony
-
5. Re: MTD and QTD Filter
Shinichiro MurakamiJul 18, 2018 6:48 AM (in response to Tony Smith)
What is the error which version you use?
Shin
-
6. Re: MTD and QTD Filter
Tony Smith Jul 18, 2018 1:43 PM (in response to Shinichiro Murakami)Hi Shin,
Sorry, I didn't explain the requirements properly when I raised this request. I now have a clearer understanding of what's required. You don't need to do any more work on this. Thank you for all your help.
Regards
Tony
-
7. Re: MTD and QTD Filter
Shinichiro MurakamiJul 18, 2018 4:05 PM (in response to Tony Smith)
OK.
Thanks,
Shin