Row Count based on month

[pathakpeeyush]

I have following table

Yes	Jan
Yes	Jan
Yes	Feb
Yes	Mar
Yes	Mar
Yes	April
Yes	April

I need it to be like

2	Jan
1	Feb
2	Mar
2	April

Can someone help me achieving this?

[mahoneypat · Accepted solution]

Yes.  In the query editor, select your month column, hit the Group By button in the ribbon on the Home tab, then choose Count as the aggregation.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat