Forum Discussion
Visual filtering
I'll put together a sample and add it to this message, I can't do real samples as its confidential data. so will do a mock up
ok so here is a sample of what i've built so far:
| Main Data Table | |||
| Customer | Utilisaton | Emp Name 1 | Emp Name 2 |
| Cust 1 | 10% | Joe Bloggs | |
| Cust 2 | 15% | Jane Bigs | Joe Bloggs |
| Cust 3 | 10% | Joe Bloggs | |
| Cust 4 | 20% | Jane Bigs | Joe Bloggs |
| Cust 5 | 10% | Jane Bigs | |
| Cust 6 | 15% | Jane Bigs |
Employee table 1 which has a relationship to Data Table Emp Name 1, this runs a calculation that looks for the Emp Name in the data table Emp Name 1 column and then sum the utilization associated. I've also used it to bring through the results from a second table and create a total (this is the part I want to change)
| Emp List table 1 | |||
| Emp Name1 | Utilization | Emp 2 Utilization | Total Utilization |
| Joe Bloggs | 20% | 35% | 55% |
| Jane Bigs | 60% | 0% | 60% |
Employee Table 2, has a relationship with Data Table Emp Name 2, does the same as the first table simply calculates the utilzation based on finding the name in Emp Name 2.
| Emp Table 2 | |
| Emp name2 | Utilzation |
| Joe Bloggs | 35% |
Ideally I want to have one Employee table that does the calculation for all the utilization, but I can't work out how to have that work when I need to look in two different columns. (Emp Name 1 and Emp Name 2). and its not possible to combine the two as the names are the same and the reason for them being there is different.