To get the columns to only show the first value for each Base type for MIN and MAX, create two calculations similar to the following:
ifnull((if index()=1 then str(lookup(min([MIN]), 1)) else ' ' end), str(lookup(min(MIN),0)))
ifnull((if index()=1 then str(lookup(max([MAX]), 1)) else ' ' end), str(lookup(max([MAX]),0)))
Then, place these on the rows shelf between Alt Part and PART_TYPE. Right click on each calculation and select Compute Using...>Alt Part.
Since these are discrete, it's not possible to add grand totals. One option may be to find the desired totals and place them on a separate worksheet, then place them all on a dashboard together.
Hope this helps!