I want to create manual cross tab.please see Image.
can any one tell me detail steps
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.
I tried to drag but month column is just changing its position.
Make sure it's a pivot table. Then drag to the upper right corner until the blue line changes from vertical to horizontal.
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.
Under chart properties -> presentation, Select "Always Fully Expanded"
Retrieving data ...