I need help in creating a formula that divides the sales of a single week by the sales of the entire year. I am utilizing a custom calendar. When I attempt to use the SUM function, I encounter the following error message: "The name ' used in the SUM clause is not recognized as a line item in the model."
I have attached an image for further clarification. Thank you in advance.