1 of 1 people found this helpful
Hi Jaspreet-- not sure if this is what you're looking for but here's my stab at it: First i created a project type field, this stores whether the project type is bigdata [which is the only value for master project, right?] or program, or independent.
Then I'd just create a calculated field that assigns a different value for budget if the project type is BigData:
I just don't see from your data/description above, where this additional cost for the master project itself is stored.
If you look at the data source the project type for a Master Project is "Master"
In the pic below I have underlined the projects along with the budget costs that belong to Big Data and circled the master project called "Big Data" itself. The value for the budget comes from the Budget Costs column and the value for the money spent comes from the "Actual Cost" column. So the value for the master project called big data will be = $200,000 + $200,000 + $200,000 + $200,000 + $50,000 = 850,000
Okay-- this may not be a long term solution but here's a way to at least get to the value you're wanting, maybe put you on the right track. I added a sheet at the end filtered for projects that contain "BigData or Big Data" and added in the total. Assuming in your second screenshot below you also meant to include project ID BigData5, then this total value is the value you're looking for.
I then recreated the barchart on the next tab using the grand total as the budget bar. Now you can just update your dashboard to fitler to that worksheet when the user clicks on Big Data.
project management sample_Liz.twbx 323.1 KB