the original excel table looks pretty much the same with the table you see on the lower left corner.
I want to figure out a way to effectively show the cost of each project.
my dimension is "Project Name" and I set my expression as
there is one problem with my approach. It works fine when all the projects share same star and end date for all of the resources.
but if person A and person B in same project have different start and end date for the project, it does not give me the correct calculation of overall project cost and I know that it is because I set my dimension as "Project Name." and I know that it is because I have set the expression as Max([End Date]) - Min([Start Date]). it will pick up the latest end date and earliest start date.
can anyone help me with a way to calculate the cost of each project correctly even though every individual involved in the project does not have the same duration of involvement into the project and when everybody has different rate?