Expand and collapse in straight table

[#1]

Expand and collapse in straight table

[#2]

Any one please help!!!

[#3]

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