How can I create multi-dimensional tables?

0
Hi, I'm trying to create an overview page displaying a large dataset. All the data comes from instances of the same entity and should be displayed as a multi-dimensional table like the example bellow. Location, day, expense and income are all attributes in this entity. Are there any ways this can be done? Thanks in advance :)   
asked
6 answers
0

You can use dynamic data grid

answered
0

Hi,

you can create your table via Datagrid2 widget 

Mendix Marketplace - Data Widgets

 

but to group columns and given common heading like Location 1 , location2 is not supported currently.

answered
0

Thanks for your answer, but I'm still not sure how to do this. If I add my entity as a data source in a normal datagrid widget it results in a table like the example image under shows. How should I configure the datagrid2 widget to make it look like the image I provided in the original post?

 

Skjermbilde 2024-10-10 083848.png

answered
0

Hi Pedersen,

 

Try use List View and create your expected table structure. And apply CSS. 

image.png

 

Hope it helps!

 

Thanks & Regards,

Manikandan K

answered
0

Thanks, I think this will help with the grouping of the columns. I still struggle to see how the rows are going to be "merged" if they have a common value in the Day column

answered
0

This post from Ideas is pretty much what I'm looking for: Mendix Community - Idea Details. Does something like this exist now? Or is there a workaround I can use?

answered