Hi Sunil,
If products and zones are different entities with an association between them, you can use an aggregate function to sum the sold items.
https://docs.mendix.com/refguide/columns/#243-aggregate-function
Base the datagrid on entity “Zone”, use xpath as datasource and add a column to the grid for the sold value.
Another option would be using OQL, which i personally find a bit exotic. See https://forum.mendix.com/link/questions/89808 for example.
I hope this helps.