Breaking apart SUM/LOOKUP
My team is working on breaking apart a particularly complicated SUM/LOOKUP formula that was built 4 years ago. Looking for guidance anyone may have out there. Here's what the scenario is:
- 5 SUMs & 2 LOOKUPs in same formula
- 2 of the 5 SUMs & the 2 LOOKUPs are traditional SUM/LOOKUP combos (so the dimensions are not in the source or target modules)
- Time is one of the dimensions SUMming on
Looking to break apart as much as possible in order to attain largest performance gain. We have hyper model, space should not be an issue.
Many thanks in advance!