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 some...
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
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