Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Complicated crosstable

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.

1 Solution

Accepted Solutions
sparur
Specialist II
Specialist II

Hello, Anya.

see in my example:

View solution in original post

2 Replies
sparur
Specialist II
Specialist II

Hello, Anya.

see in my example:

Not applicable
Author

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