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!
It's quite difficult to understand what you want to achieve only from the screenshot.
Could you attach packaged workbook (**.twbx) ?