My organization creates numerous projects and tags them as "awarded" and "proposed". We would like to create a view in the data analysis that lists resources by week and resource type, then indicates their work and how much remaining
capacity for work the resource has remaining. I would like the pivot table graph to be a column graph that stacks Awarded work, Proposed Work, and remaining capacity for work on top of one-another. Is this possible?
I have created the pivot table, but so far I end up with multiple "remaining capacity" fields where each subtracts the Awarded work from the total capacity or the proposed work from the total capacity. The end result is a graph with *two* "remaining
capacity" fields, and an inaccurate representation of the resources' actual remaining capacity.
