Filter rows as sub heading

[justin777]

Hi, 

Is it possible to make a field as a filtered sub heading? 
I'm not sure what is the proper term but for example:

Department	Project
Department 1
	People 1
	People 2
	People 3
Department 2
	People 4
Department 3
	People 5
	People 6

People 1-3 has Department 1, People 4 has Department 2 and People 5-6 has Deparment 3. 
As you can see they are filtered/group by Department which is a sub heading for the ones below it (It also works even if the first one is on the same row as department) 

[Seward12533 · Accepted solution]

The Matrix Visual should do this for you automatically (make sure to expand it to include the additonal columns which are by default hidden. (double down arrow).  If you want a separate columns be sure to turn off Stepped Layout under Row Header section of formatting pane.