Hi everyone!
I'd appreciate if someone could help me with the following problem:
I have multiple flat tables (sales forecasts) from different sources, which I'm trying to combine into one pivot table. The tables are strucutred the same way (i.e. same columns) but have vastly different sizes.
So far, I've joined them using PQ and then turned the combined table into a pivot table. I've been trying to accomplish this more elegantly without the extra PQ detour. This seems like such a basic task, but so far haven't succeeded.
Is this possible at all, and if so, how?
I've attached a small sample file.
Thanks!
Bookmarks