Hi, I have a pivot table and columns YearMonth, week, Agreement, amount, and project. The agreement for each project is determined for each month. And what I want to do is when I expand month to week, I want to divide the agreement equally for each week (weekdays) in that month.
For exapmple, if the agreement for Project AAA is 100 for each month, In October 2020, for example, we have five weeks The Agreement should be divided equally into five weeks and the first week the first week(week 40) has only two working days so should get 4.54 all the other four weeks have 5 working days , so they should get 22.7.
Oh, Sorry, it should be 9.09 for week 40. If the value(Agreement) for October is 100 since we have five weeks in October 2020, the amount 100 divided by five weeks will be 9.09, 22.7, 22.7, 22.7, 22.7 when you add them together, it will be 100. We have 9.09 for the first week( week 40) because we have two working days in that week for October.