What is the best way to get summary reports for Dynamics 365? I have a requirement where I need to count the number of an entity by status. I can use a chart and display this information, but I'd like to display it in a table format where it's just a table and each row just has a status and the number of records for that status. Basically like the sample table below.
Status | Count |
Pending | 4 |
Active | 89 |
Deleted | 3 |
Completed | 49 |
No matter how I group or add columns, I can't figure out how I'd do it in the Report Wizard.