Group at department instead of employee level

[#1]

I am trying to create utilization dashboard for the department where utilization percentage is less than 50.
In the dashboard tehre are two object one is bar chart and other is pivot table

In bar chart dimention is department and expession is utilization %

In Pivot table dimension is department employee name and expression is utilization %

vLowUti=50

Below is expession that I am using

if(
((
SUM({$<[Expenditure Category]={"Chargeable Hours"},[Project Type]={"Contract"},FY ={$(vCY)},[Bu Admin] = {"N"}>} [Actual Hours])
)*100)<= vLowUti,
(SUM({$<[Expenditure Category]={"Chargeable Hours"},[Project Type]={"Contract"},FY ={$(vCY)},[Bu Admin] = {"N"}>} [Actual Hours])

)
)

When I am taking utilization at department then I am getting all those department where utilization is less than 50 but as soon as I insert employee
name then it start giving employee utilization where it is less than 50.
I want to show department as well employee but only for departmnet where utilization is less than 50.

[deepakk · Accepted solution]

My Dear Nishany

Try out this.

[#3]

Hey Deepak,

Its working, U r gem man.

Thanks a lot.

Nishant.

[#4]

Hey Deepak,

Its working, U r gem man.

Thanks a lot.

Nishant.