Crystal reports 2011 for enterprise and SAP BW

Hi guys

I'm using Crystal reports for enterprise XI 4.0 and I try to connect to a simple query that has 4 key figures on the rows and Calendar year month on the columns.

I'm connecting to BW through BICS and I manage to see my query.

My problem is that I need my report to be designed as a crosstab, as BW is showing it and in Crystal I get everything in columns.

I tried to insert a crosstab but I couldn't make it appear the way I wanted it.

Any help will be appreciated

Shlomi