1. Create a calculated column "Status" with a rule that would output "Active" or "Inactive"2. Use that column as the category field and, say, the ID field as the value field3. Check "Aggregate over category" and select "count" as the function

Thanks for your response.Unfortunately, the suggested solution didn't work out, it freezes after request init, it never resolves the replaced code of request success. I'm using office 365 enterprise E3 plan here if that helps debugging the code. Please advise.