I have a table having “Team Member” , “Team Member Profession” ,” No.Booked” , “No.Available” fields
I have filters “Team Member filter”, “Profession filter”
When I select one Team Member from filter , I can get “UTILIZATION” kpi figure with following formula
And when I filter Team Member, its associated “Professions remain active in “Profession Filter” while all other gets disable(Greyed). When I select that Profession from filter pan, I get another KPI figure for profession utilization with following formula.
But my requirement is that when I select Team Member it should give me the Profession utilization figurewithout explicitly selecting filtered out “Profession” based on Team Member Selected. How can I change my profession utilization formula to achieve this.