Forum Discussion
Row Count based on month
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?
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
1 Reply
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