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.