Forum Discussion

InsightsByV's avatar
InsightsByV
Super User
3 years ago
Solved

Fiscal Week

Hi,   I need to show Fiscal weeks for each month. The year starts from April 2022 and I am able to get fiscal week numbers starting from 1 to 52.  BUT - it should show week-1, week-2,... for each ...
Need Help
InsightsByV's avatar
InsightsByV
Super User
3 years ago

Hi,

 

Thanks for your quick resonse, I have implemented your suggestion but it still gives me data in week-1 till week-52.  I need to show weeks in below manner for month filter.

 

Month: (for selected month)

Week 1Week 2Week 3Week 4Week 5
valuevaluevaluevaluevalue
     
     
     

 

Financial year starts from 1st April. For each month, data should be visible in the above way. So irrespective of the month selected, week number should be dispalyed as week-1 till week5 according to the month's weeks.