How to group data from one column?

[0xygen27]

Dear Community, 

I am wondering about a formula I want to use. I got a database with a column for

-Date

-Department

-Employees

I am wondering if i can use a formula to group some departments in a group in a different table. For example group Sales department and marketing department.

All the departments are now only in one column.

Greetings, 0xygen27. 

[haymanezzeldin]

@0xygen27

Is there a criteria that combines these departments under a specific group?

Regards,

Hayman

[0xygen27]

I don't think there is a criteria that combines the departements with each other. I am looking for 3 groups in which I can place these departments (For example :primary process,Secondary and administrative process) 

Is there a formula where I can make a Table and filter particulair departements into that table?

So the columns are like this 

Column

Date Column Department Column Employees Column Phones active at department

11-02-16        Sales                           110                         60 

11-02-16        Purchase                     60                            40

11-02-16        Bosses                         4                             4

18-02-17        Sales                           110                         60 

18-02-17        Purchase                     60                            40

18-02-17        Bosses                         4                             4

28-03-17        Sales                           110                         60 

28-03-17        Purchase                     60                            40

27-03-17        Bosses                         4                             4

I want to place Sales and Purchase in a Table together and name it Primary process, So i can show how many % of the Primary process uses a phone and filter on it.

I want to make a chart which shows me the information of my whole company and in which I can zoom in on the 3 groups and then zoom in on the departments.

[haymanezzeldin]

@0xygen27

You can use Calculated Tables to create a copy of the existing one, and just use DAX filter to eleminate the Bosses records:

Table = Filter(Sheet1, Sheet1[Department]<>"Bosses")

Regards,

Hayman

[0xygen27]

Holy, thank you.  It is working. Is there also another function which I can use the opposite way? So that I only have to type the things I want in it? I got a lot of departments to work with ^^ 

[haymanezzeldin · Accepted solution]

@0xygen27

In such situation you can use multiple filter using the "or" sign ||, as follows:

Table = Filter(Sheet1, Sheet1[Department]="Sales"||Sheet1[Department]="Purchase")

Regards,

Hayman

[0xygen27]

Thank you for helping me out!