I want to build a portal page that shows a table that the user can filter dynamically, with two sets of picklist filters: one set to select which records will be shown across rows, and another set to determine which fields will be displayed down columns. (For simplicity let's say we're only dealing with one object without any grid mapping.)
As an illustration, with an object representing past sales of a company: the user can select from the first set to display sales from certain regions, or above a certain dollar value, or of a certain product, and then from the second set to determine that the fields displayed down the columns will be the ones related to financial information about the sale, or customer information, or product details.
Any suggestions will be much appreciated!
Thank you, Orchid. That is useful for the search function in our portal but not quite as flexible as I need for another view to be able to filter and access data dynamically. Would reports provide such functionality?
Thank you, Orchid!