Report - % complete by color
I am trying to create a report that will sum all number of items that are assigned to a color (red/yellow/green) under each parent row in Index ID column but when I create the report it is not allowing anything related to the colors. Wondering if I need to assign a number or a hidden column to define what each color represents and filter that way. Also wondering how I could create a % for each color under their parent row - assume would be more of a formula on the sheet and not the report but would like it all consolidated if possible. Any help would be great!!!!
Help Article Resources
Check out the Formula Handbook template!