I want to See the total Male and Female Count of a State From Two table Employee And State

kindly Suggest me OQL For this  i want to create layout like this Where i need to get a count of Male and Female Employees On the behalf of State and City
1 answers

In order to count items stored in your entity I normally use a non-persistent entity that is counting the items based on the selection of the user. The non-persistent entity holds a attribute for example “total” what can be displayed on the page.

The calculation in that case is done with a Microflow before entering the page