I have a ragged Manager hierarchy (see attached ss) which I would like to flatten, but absolutely can’t get my head around how to do it. The Manager column is related to a dept table and onto the fact table.
I am trying to create a table visual with All Managers and YTD, Bud, LY etc regardless of postion in hierarchy. (once I have this I need to do some ranking which is pretty straight forward). But I want all managers in the hierarchy in one list regardless of hierarchy level. At the moment when I Use the manager column in the table it is only summing in accordance with the relationship. So for example Manager SS does not report any figs because he controls numerous depts. Manager DB only has figs for 1 dept whihc he controls directly, no figs for the sum of the reportees he has.
I hope I’ve explained the problem well enough.
Any help greatly appreciated.
PeteDev.xlsx (9.7 KB)