Relationship Help? Need Sales Comparison
I need to compare sales on a daily basis by day of week and week of fiscal year, on a per-location basis. I've managed to get the calendaring worked out, but I don't know how to approach the prior year sales. I'd like to do the past three years, ideally.
I tried to set up field in Sales for the PY1 numbers, but can't get it to populate with the data no matter how hard I try. Open to anything that works, even if it's a different solution entirely. I'm not married to anything but the end result.