Forum Discussion
How to group data from one column?
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.
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
6 Replies
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.
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