Complicated crosstable

[#1]

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.

[sparur · Accepted solution]

Hello, Anya.

see in my example:

[#3]

That's exactly what I meant, thank you so much!