Thank you for your response. Yes I am aware of the scope control. If I select per cell it will add every spend type's amount cut to ever spend type. So each one would have would have all of the other cut amounts. I have changed it to that in the attached work book for your convencience.
I guess I would like to control which shows up where? or some sory of parameter to make the approiate line show up for the approriate bar?
Again I appreaciate your help.
Mockdash.twbx.zip 53.8 KB
Then I suggest that instead of making calculated fields for each type, you make one for all types, using IF statement that will apply relevant amounts of cut, like the one below (add your remaining types using the same pattern). This way you only need one reference line, and it will apply the right calculation based on the type, and will show nothing if there is no cut for that type, rather than 0 and a redundant label.
[Spend Type] = "Equipment" then ([Budget]-[Spent])*(1-[Equipment Amount Cut])
[Spend Type] = "Labor" then ([Budget]-[Spent])*(1-[Labor Amount Cut])
//etc. - add remaining types here