Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Problem with 3 table matrix

Hi!

 

I need a matrix where I can see the real headcount vs de budget, depending on the type of employee and group by their acoounts.

This are my 3 tables:

 

Real employees:

AccountNameAño (year)MONTHTipo (type)
2025015200JUAN MANUEL202112Sindicalizado
2025015200OSCAR IVAN202112Sindicalizado
2025015200ALEJANDRO202112Sindicalizado
2025005400ENRIQUE202112No Sindizado
2025005400JOSE LUIS202112No Sindizado
2025015200MANUEL RAUL202112No Sindizado
2025015200LUIS MIGUEL202112No Sindizado
2025015200MARIO202112No Sindizado
2025015200YAN CARLOS202112No Sindizado
2025015200VICTOR HUGO202112No Sindizado
2025015200JUAN DANIEL202112No Sindizado
2025015200LEONEL ALEJANDRO202112No Sindizado
2025015200ALEXIS HERIBERTO202112No Sindizado
2025015200ALDO202112No Sindizado
2025015200OMAR GERARDO202112No Sindizado

 

The budget, depending on the type of employee:

AccountSINDICALIZADONO SINDICALIZADOSAño (Year)
2025005400302021
2025015200832021
2025405248102021
2025005400302022
2025015200832022
2025405248102022

 

And the information about he accounts:

AccountCITYUN
2022085200CuauhtémocRM
2025005400CuauhtémocRM
2025008623CuauhtémocRM
2025015200CuauhtémocRM
2025035200CuauhtémocRM
2025055200CuauhtémocRM
2025065200CuauhtémocRM
2025405248CuauhtémocRM

 

And i need a matrix that can be filter by:

  • Year: same budget all year
  • Month: the real emplooyes will modify each month
  • Type of employee, so i can se 3 diferent scenarios as i show you next
  • And expand the selection so i can see the names of the employees that are in the account

 

 

 

I used 2 slicer of the same name to show you the examples, but i need just one of each one.

Thanks!

 

 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks, but the problem is that when I use them like that, the matrix didn't work like I wish... it filters only the data of the employee, I mean, if I have no employee in an account, the matrix don't show me the budget of that account.