AnsweredAssumed Answered

Relationship Help? Need Sales Comparison

Question asked by kathleen_r on Sep 16, 2011
Latest reply on Sep 16, 2011 by philmodjunk

Title

Relationship Help? Need Sales Comparison

Post

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.

Thank you.

 

Screen_Shot_2011-09-16_at_11.39.22_AM.png

Outcomes