Comments
-
I ended up using an ETL to restructure the data as needed
-
Yah, I know it's tricky. See attached. That's kinda what I'd expect (it's using the aforementioned formula), accept the values should be much higher.
-
No, that doesn't quite work. I can see how each channel is doing currently. But I don't see any trends. The goal would be to see the running total each month, at the same time. For instance... (we sell bar & wine accessories) During Q4 I would expect our Liquor Store channel to increase in value. During the spring, I would…