Hi I am not well versed with SF reports and wanted some help with a matrix report that I am trying to put together.
Lets say I have a custom object to store records that have a start date and end date. This object is a child object in a Master-Detail relationship with another object. The custom object also has a percent field to store Distribution.
Lets say I have two records:
1. Record 1 Start Date: 02/17 End Date: 03/15 Distribution % = 60% 2. Record 2 Start Date: 03/17 End Date: 04/3 Distribution % = 100%
Right now in my report, I have a column grouping for End Date and have grouped dates by Calendar week. The Distribution percentage field has been added as a summarized row and as an average.
For the first record for example, I expected to see 60% marked in all the cells for every week starting 03/16-3/22 and so on.
But the 60% appears only under the column 3/30 - 4/5.
How it should look
2/16-2/22 2/23-3/1 3/2-3/8 3/9-3/15 3/17-3/22 3/23-3/29 3/31-4/5................... Record 1 60% 60% 60% 60% Record 2 100% 100% 100%
How it looks
2/16-2/22 2/23-3/1 3/2-3/8 3/9-3/15 3/17-3/22 3/23-3/29 3/31-4/5................... Record 1 60% Record 2 100%
So how can I change this to show that the distribution is 60% in all the cells beginning from the week containing the start date to the week containing the end date.
I hope this made sense. Thanks.