Sum of Hierarchy Level Available Hours

[durgaranga]

Hi All,

I have below data set and I want to sum all the available hours for each heirarchy. Can anyone help on the formula.

 

And I want the output result as below.

Any help is highly appreciated.

Thanks

Durga

[Anonymous · Accepted solution]

Hi @durgaranga

Create a measure

Total Hrs= Sum( Avail_hrs)

and pull all columns along with this measure, this will aggregate the values based on the column you pull into visuals.

Thanks
Raj

[Anonymous · Accepted solution]

Hi @durgaranga

Create a measure

Total Hrs= Sum( Avail_hrs)

and pull all columns along with this measure, this will aggregate the values based on the column you pull into visuals.

Thanks
Raj

[durgaranga · Accepted solution]

Thanks a lot Rajendran. It worked.