I'm fairly new to this so please bear with me.
I am trying to create a Table for Market Sectors webpages that show information from projects that relate to that specific market sector.
I have a data collection that contains the project specific information. It is used to create dynamic pages for each project entry. This collection has a column in it that identifies the Market sector the project was undertaken in.
What is the process to populate a Table with only the market specific projects (filter for projects in specific markets)?
In Excel I would use a pivot Table to do this, but could use some pointers on how this is done in WIX.