Need Month wise Pivot

[udprocks]

Dear All,

Can Anyone please help me with this i have a master file with dates of respected month,

when i applying pivot table in this it showing date wise details , it is possible ? can i apply pivot for month only i dont want date wise count i want only month wise count in this..


thanks in advance...

 

[Somendra Misra]

Hi Jetendra,

See the file. I had also converted your data to table so that you need not select entire column in data source of pivot, this way your data will update in pivot and it will not show blank in row label.

Regards,

 

[udprocks]

Hi Jetendra,

See the file. I had also converted your data to table so that you need not select entire column in data source of pivot, this way your data will update in pivot and it will not show blank in row label.

Regards,

Thank you somendra sir,

its exactly what i want...