Categorizing documents

I have the following views in a db:

These documents where created with a form “MainForm” and the view selection for all views is "Select Form = “MainForm”. All fields (Boss, MGR and Employee) are normal, type Text.

Now I’m trying to build a view like this:

But I’m not managing to build it.

Can anybody help me?

Thanks in advance

Renan

Subject: Categorizing documents

Try a column with this formula:

("Boss" + Boss) : ("MGR" + Mgr )

Subject: RE: Categorizing documents

Hey Tim, you saved my day!!!

I have tried so many solutions, but none of them was working.

BTW, I had to fix your formula to (“Boss\” + Boss) : (“MGR\” + Mgr )

Working like a charm!

Thanks