I have a report where one of the fields "cube" in the details sections is the same for each line showing the cube used for that total route listed by stop number. Next, I have the correct value listed in the group section using standard running total but need to now break down further to analyis cube by locationid. However, i am unable to do this using standard running total as i need it to evaluate based on the location ID but but because the same value is loaded on the details section for each line i cannot get to total correctly in the group footer for DATE.
Attached is a small sample of what I am deaing with showing two route and current GROUP 1 in yellow and Requested data in RED for GROUP 2.
I am sure there is an easy way to do this but need help from experts.