This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I recommend not adding the columns back in the summarize tool, being that this will no longer get you Sum Sales by period. You will now have multiple rows for each period. I would instead do something like the photo below. Pull back the information that you need by using a Find Replace or Join after the calculations have been made.
Hope this helps, if so please mark this answer a solution.