Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm trying to load an Excel table (see attached example) that has budget/actual/forecast per period as column headers. I want to be able to create a report showing budgets and actual per period (per client). I've been trying to work it out useing the crosstable function but since the columns consist of 2 dimensions (period and actual/budget) I can't seem to work it out. Any help would be appreciated.
Hello, Anya.
see in my example:
That's exactly what I meant, thank you so much!