I have a database of Companies. Each company has multiple locations. Each location has assets. I have created portals to list the assets that for each location and the entire company. Each asset has a type (chair, desk, table, etc...). In my current portal for each location i have a list of assets (chair, chair, chair, desk, desk, table), I would like to see a portal list that displayed Chair (3), Desk (2), Table (1) and be able to "drill down" to the asset I am looking for. Also for the company, I would like to see a total count for all locations. Stumped?!