Total sales group by manager hierarchy and team

[Anonymous]

Hi everyone,

I'm having trouble making pivoting based on country region and manager team/team leads. For file and table relationships, I have made it like this: CS-2.pbix 

For now I have made a target table per person based on a month and also an employee table along with reporting to or to the team leader. Can you help me to accumulate the target number and the total number of room nights based on the group that I have mentioned. Desired result like this below:

Thank you

[Anonymous]

Hi @Anonymous,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your requirements.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[parry2k]

@Anonymous is this a new question? Did you get the answer to your original question?

[parry2k · Accepted solution]

@Anonymous first, why do you have duplicate employees in the employee table, seems like that is the first issue. once you fixed that, you should be able to use matrix visual:

On rows: report to and employee name,

On value:  target from target table and total rooms from jun table and then should do it.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Okay, I have done remove duplicates with the employee email. But, how can you help me again, can I just show with the active employee, that I mean only showing in a table with an employee who is not in the resign date column. My table shows all employees (Active and Inactive) when I filtered with a month in the slicer.

Thank you