1 Reply Latest reply on Oct 4, 2016 6:16 AM by Shinichiro Murakami

    To calculate total hours for each dimension within a category

    Anusha Acharya

      Hello,

       

      I am trying to calculate total hours across each dimension in a category .

       

      Problem Statement : I have two dimensions Support and development. I want to understand Total number of hours consumed in order to meet the target hours. I have target hours for support as 520 and development as 1600. I'm trying to plot a trend line to measure the same. I tried formulas 1600 - Total ( Avg([Hours])), 1600 - Running Sum(Sum([Hours])). This isn't giving me what I am looking for. Please find attached screen shot that I'm trying to visualize.

       

      Any help is highly appreciated!