Loading data for pivot table

[Anonymous]

Dear all,

I have an excel sheet that looks like this.

Costumer	Jan	Feb	Mar	Apr
A	5200	5642	4520	6300
B	4500	210	3520	1205
C	4500	2000	1520	8520
........

I already experienced Pivot as a possible solution to present the data, but how do I load it the best way? I think loading the months as dimensions won't work for this.

Thank you

Tom    

[sunny_talwar · Accepted solution]

May be check here

The Crosstable Load