cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
justin777 Frequent Visitor
Frequent Visitor

Filter rows as sub heading

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:

 

DepartmentProject
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) 

1 ACCEPTED SOLUTION

Accepted Solutions
Seward12533 New Contributor
New Contributor

Re: Filter rows as sub heading

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. 

1 REPLY 1
Seward12533 New Contributor
New Contributor

Re: Filter rows as sub heading

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.