Hi Folks,
I am trying to bring in my company org structure into a pivot. Main objective is to see total FTE headcount or associated cost at any layer using data structured into a pivot.
I've attached a simple example of the Raw data I get and what is the Output I am looking for preferably into a pivot.
This is just an example dataset, I've a large live dataset which is very dynamic and will keep on changing every two weeks.
So would need to be able to manipulate my current Raw data in some shape or form, which can provide me a final output in a pivot just like how I've shown in the attached Excel.
Any help on this will be much appreciated please.
Thanks
Rahul
I am trying to bring in my company org structure into a pivot. Main objective is to see total FTE headcount or associated cost at any layer using data structured into a pivot.
I've attached a simple example of the Raw data I get and what is the Output I am looking for preferably into a pivot.
This is just an example dataset, I've a large live dataset which is very dynamic and will keep on changing every two weeks.
So would need to be able to manipulate my current Raw data in some shape or form, which can provide me a final output in a pivot just like how I've shown in the attached Excel.
Any help on this will be much appreciated please.
Thanks
Rahul