Forum Discussion
Help needed with building multi dimensional formula
Hi Team, I need help building a logic in excel, here’s what I’m trying to do: I have two tabs in excel, sheet 1 and the other is sales tab, In sheet 1, I have following data points: The dates are...
Thanks for your help, appreciated!! this logic is giving me the result I need in column H, just have a quick question- this logic right now is pulling values just for one UCN, and I have around10,000+ line items for different UCns, Is there a way to tweak this logic so that it works for range of UCNs
Thank you!
Hi,
Will the attached work?
I just assume your data will always be in this order:
Row1: DSeA, Row2: SCC, Row3: SV
If you don’t want DSeA, you just need to enter Measure Start Date = 31/12/2023, and Measure End Date = 01/01/2023, the resulting YTD will be zero.
Similar for SCC, SV. Like below:
