Forum Discussion
Solved
Matrix Style Sheet
Hi, I have a sharepoint site that I use for employee competency management one of the lists stores roles and their associated competencies. Is there a way to create a report that displays...
scottfos Wouldn't a pivot table do just that? Row in the Row field, Competency in the Column field and count of Role in the Value field. Then use conditional formatting to color all cells in the table that are equal to 1.
scottfos Wouldn't a pivot table do just that? Row in the Row field, Competency in the Column field and count of Role in the Value field. Then use conditional formatting to color all cells in the table that are equal to 1.
Thanks Riny_van_Eekelen that worked great for me, its time to learn about pivot tables.
