Forum Discussion
Custom calendar
How about this as a pivot table presentation:
I stayed with Wednesday being the start of a week so that my results match your results.
Change your end date in cell 'end' to one within the first 2 or 3 weeks of the year to see what happens when you refresh the pivot at cell V13.
See the calendar query in the attached which outputs directly to the pivot.
Hope it gives you some ideas.
Edit: Note, that if you want the week to begin on a Monday, there are 2 places where you need to change that:
1. The first step called FirstDateOfWeekNos where you change Day.Wednesday to Day.Monday (or just delete Day.Wednesday and its preceding comma since Monday is the default if you don't supply that argument), and
2. The step called Inserted Start of Week where you do the same.
SundarRaj , did you post the correct file with your changes?
I don't see any difference with mine.
tharunkumarRTK ,thank you very much, I took inspiration from your last two lines of code and integrated them into mine. It works well (see new file)
I think I'll adapt the number of weeks to ISO to start from a full week.
My only problem is that I have to manually modify this part "#duration(26,0,0,0)", so that the first of the last four weeks starts on a Monday.
I'm waiting to see the solution from SundarRaj to see which solution to go with.
Best regards
Hi Mederic ,
I'm sorry for sending out the original file (no changes). I'll attach the file with the transformations. Also, with respect to the selecting the first of the four weeks that starts on a Monday is also incorporated here. Here is the image below:Here is the output:
Regards,
