Hi wiselin21,
Straight Table does not have that feature. Instead of straight table,use pivot chart.
Only pivot chart object has the feature to expand/collapse the dimensions used in the chart.
Pivot chart has the feature to do partial sum,which sums the values and shows it on collapse.
Hope this helps,
Regards,
Snehal Nabar