Pivot tables in Mendix

Currently Our organization has some data which is stored in excel sheets and they are applying pivot table rules to see the data in aggregegation. Here the user has flexibility to choose coulmns and rows what should be displayed. In addition to that if user selects multiple columns the data aggregation happened at 2 levels. e.g.  Unit A has total 90 people And inside Unit A, assume 3 sub-units. So when you select both Unit Sub-Unit for your pivot table it displays sub-unit level information as well.   Now How to build the similar functionality in Mendix. I could achieve up to one level of aggregation but having a multi-level aggregation is something I am unable to figure it out. Can some one help me on this.
0 answers