Forum Discussion

justin777's avatar
justin777
Frequent Visitor
8 years ago
Solved

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) 

  • Seward12533's avatar
    Seward12533
    8 years ago

    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

  • Seward12533's avatar
    Seward12533
    Solution Sage
    8 years ago

    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.