Hi Community, I'm trying to build a Case report in Salesforce and need some guidance on the configuration. **Requirement Overview:** I need a summary report on the Case object that groups data by two fields: - **Record Type** (standard field) - **Request** (custom field) For each unique combination of Record Type + Request, I need the following three columns: 1. **Closed Cases Count** – Count of cases where the Status picklist field contains "Closed" 2. **Open/Non-Closed Cases Count** – Count of cases where the Status field does NOT contain "Closed" 3. **SLA Missed Count** – Count of cases where the SLAMissed field (checkbox) is TRUE **What I've tried / Where I'm stuck:** I can group by Record Type and Request easily, but I'm struggling to get three separate conditional counts in the same report row. Salesforce summary reports don't natively support conditional column counts (like COUNTIF in Excel), so I'm not sure of the best approach. **Questions:** - Is this achievable with a native Salesforce Summary or Matrix report using bucket fields or custom summary formula. Any guidance or examples would be greatly appreciated. Thanks in advance!
Can you post screenshots of the Report, showing the Report Type, the Settings, and Filters that you're currently using, the results you're currently getting, and a mock-up of what you want?
For questions related to Reports and Dashboards those are really helpful
