I have the following data which represents rack locations in a warehouse. Locations ending in 10 are the bottom level, 20 is 2nd level, 30 is 3rd and 40 is 4th. The list displays utilization in those racks. I would like to be able to take all the values ending in 10 and figure out the total % utilization for those racks, and then do the same for the locations ending in 20, 30, and 40, ideally without having to re-sort the data. In the following example, there are 2 locations that end in 10, both of which are 100% utilized, so the result I'm looking for would be to have a cell at the bottom of my list report 100% for those locations.
Location Capacity utilization % utilization
LP11100110 5 5 100
LP11100120 5 5 100
LP11100130 5 1 20
LP11100140 5 5 100
LP11100210 4 4 100
LP11100220 4 2 50
LP11100230 4 1 25
LP11100240 4 4 100
Bookmarks