Sort data by color thro Pivot table

Hi All,

Hope everyone is safe & doing well.
I have a excel sheet as a Progress tracker for multiple products manufactured at different sites and i need to track the activity related to gathering of data for a Risk assessment exercise.

so basically, for any product you have the information in columns as below:
- Product
- Product configuration (volume in ml or mg)
- Site (at which the product is produced)
- Pack format (e.g.- bottle, vials etc.)
- Pack details (specs of the pack format)
- RPT no (Database no. which needs to be looked thro for the below mentioned details):
- DPQ (sort of questionnaire)
- Specs (just indicating whether the specs are available in full (green), if data is in WIP then it is amber colored, if not available or pending, then it is Red
- Suppliers (1,2,3 indicating different suppliers - all cells against these suppliers would turn green, amber, red, depending upon the data they are required to furnish for risk assessment - details are mentioned in the excel sheet)

So, basically am looking to create a summary of the data (may be a pivot table); where I should be able to see the data sorted by color for respective products (with ther respective sites). There might be cases where for a specific site there could be multiple products.
Also, I am looking to get the count of the progress for columns H thro L , meaning, DPQ, Specs & Suppliers (either could be completed (which means green color) is in WIP(which means Amber color) or Pending(which means Red color))

Hope I was able to explain myself in a proper manner.

I have attached sample excel sheet with some example data.

Please help/support.

Thanks,
Mahesh