hello all,
Hope all is well. I am having trouble separating weeks properly from my data set. If you look at the excel file that I have attached to this email. You will see that I have used grouping to separate dates according to weeks (7 days). But its not accurate enough. for example, If you look at column D of the CRMReport sheet. You will see that week one starts on August 1, 2018 (Wednesday) and ends August 5, 2018 (Sunday). Only 5 days are in the first week. After the first week each week is has 7 days. How do I find a solution to this problem? So basically I want the week to be filter from Monday - Sunday in a month using pivot table. How can I accomplish this
Bookmarks