Similar Variable in Pivot Table appearing as sub groups

[anuradhagrewal]

Hi
I am facing this problem
I have the daily work score of 100 candidates for Jan, Feb and so till Dec.

I want to find their average score for each month like Jan, Feb .....

The Months are arranged in rows and the candidates are arranged in columns
Now when I want to create an average using Pivot Table , the pivot table instead of taking the month i.e Jan as one variable makes it 20 variables and so on.
Like January 2 , January 3 etc

Row Labels	Avgof January	Avg of January4	Avg of January3	Avgof January2
Candidate 1	63.23​	62.71​	56.65​	54.72​
Candidate 10	78.34​	75.22​	81.23​	77.09​
Candidate 100	30.34​	52.32​	38.25​	47.49​
Candidate 101	64.9​	57.82​	40.06​	47.67​
Candidate 102	35.03​	32.28​	29.99​	39.63​
Candidate 103	67.09​	62.99​	45.15​	62.44​
Candidate 104	41.41​	65.05​	48.86​	48.99​
Candidate 105	44.76​	52.55​	62.76​	35.13​
Candidate 106	35.53​	53.4​	35.48​	49.43​
Candidate 107	81.74​	37.9​	37.66​	64.75​
Candidate 108	56.44​	68​	44.61​	49.92​
Candidate 109	16.83​	35.81​	39.72​	47.14​
Candidate 11	64.03​	83.14​	63.35​	70.21​
Candidate 110	43.35​	51.42​	89.15​	44.53​
Candidate 111	29.41​	16.87​	29.92​	46.64​
Candidate 112	55.65​	53.36​	44.31​	52.66​
Candidate 113	38.97​	29.09​	32.46​	29.71​
Candidate 114	42.08​	48.49​	55.04​	58.22​
Candidate 115	60.66​	68.7​	69.21​	43.15​

What can I do that all the rows with Jan open as one item in the pivot table.

 

[RoryA]

Right-click one of the date values and choose Group, then group by months.

 

[anuradhagrewal]

Right-click one of the date values and choose Group, then group by months.

I have already tried it but it shows as Jan2 , Jan 3 and so on

 

[RoryA]

What does your field list look like? There should only be one field in the Column fields area - the newly created Month field.