manual Cross Tab

[#1]

Hi,

I want to create manual cross tab.
please see Image.

can any one tell me detail steps

[rwunderlich · Accepted solution]

Create a pivot table with Project, Class and Month as Dimensions. Grab the heading of the Month column and drag to the upper right corner.

-Rob

[#3]

I tried to drag but month column is just changing its position.

[rwunderlich]

Make sure it's a pivot table. Then drag to the upper right corner until the blue line changes from vertical to horizontal.

-Rob

[#5]

Oh thanks its working.
now one more request.
on project box it is showing + sign which is suppressing class I want to remove that + sign.

[#6]

Under chart properties -> presentation, Select "Always Fully Expanded"