How can i display grouped row in the grid instead of all?

0
    I am getting all the rows having for each product details.   Suppose    Product   Month   sold    zone A                jan         10       VU B                jan          20       VU C                Jan           30        Vu Total number of sold products are : 60 on page   i want to display total number of sold product in VU Zone but righ now i am getting all.
asked
1 answers
1

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. 

answered