Reply
Frequent Visitor
Posts: 7
Registered: ‎07-11-2018
Accepted Solution

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) 


Accepted Solutions
New Contributor
Posts: 444
Registered: ‎02-15-2018

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. 

View solution in original post


All Replies
New Contributor
Posts: 444
Registered: ‎02-15-2018

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.