Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to handle a cross table with several levels, it looks like this:
Any ideas?
Thanks!
Well, unfortunately, CROSSTABLE load doesn't hand;e this situation "out of the box" ...
So, if your data structure is fairly static, You can separate it into 2 CROSSTABLE loads - first, load only Budgets, and then, load only Actuals.
Otherwise, you need to read each column separately and identify separately what belongs to what - quite messy, I have to say...