my boss want to comapre the turnover development of the new concept. That means that a retail store is closed for one or more weeks for rebuilding and opend again with the new concept. I must create a pivot tabele wich shows the sales of the year per week and store including the empty weeks. And I must calculate two sums the first one which is the total of the first part of the year before the rebuild and the seconed one is the last part of the year after the rebuild.
How did I manage to seperate these two parts in a function? The problem is that the only indication is the empty week without sales.
