Forum Discussion
hellomf
Mar 01, 2025Copper Contributor
Calculate same period in Excel
Hi everyone, I am trying to use excel to achieve the following but not sure if it something possible. For some reasons, I need it to be in excel. I have a sale sheet with customer's sales and v...
ScottAng
Mar 06, 2025Brass Contributor
Made some changes on the % calculation from "Visit - Sales" to "Current Sales - Previous Sales". Also added few columns for fiscal periods for the breakdown table. Made a few pivot tables in Sheet2, one of them should fit your request.