In tab 7.08 I would like and additional column between actual total cost and planned cost on tab 7.08. The column should be Actual Program FY just like on the lower screen print. This column should indicate the total expenses for that WBS that are in the fiscal year that the WBS was created.
Can someone help me with to interpret this as formula in the new line item "Actual Program FY" that I should create.
@Arjie We would require more information. You would need to provide the following:
@Arjie The relationship between Marketing and Sales program based on the information you have provided is not straight forward as either is a parent of the other.
3. Answer to item 2 will determine the dimensionality of the mapping module between sales and marketing programs. Easiest would be one to one and you could potentially use an existing module you already have or create a module which has one dimension. For your intentions it would only be dimensioned by sales program. Worst case scenario is many to many in which case you may need to have a mapping module dimensioned by both marketing programs and sales programs. If it is one to many, would it be possible to have the relationship as one to one if you capture mapping at a lower level of the hierarchy, e.g. Promoted Products? If yes, you would just need a mapping module dimensioned by Promoted Products otherwise you will need to have your mapping module dimensioned by both Marketing Programs and Sales Programs.
4. Now how do you derive it. I'm inferring the following relationships (which may be wrong) based on the data you have provided.
Not really sure if my response addresses your problem but hope this helps.
Ok thanks a lot, this is such a big help.