Hi There, I'm trying to calculate relative percentages in a table. I'm looking at the NAICS groupings and trying to calculate the relative percentages of companies, based on a company_name field, and facility size, based on a facility_size field. So I need to sum all of the companies that belong to that specific industry, and then divide it by all of the companies across all industries. How might I do this? It needs to be general, as a filter on my dashboard will be industry groupings.
