pivot table functionaliy by hiding & moving poisition of objects

[Anonymous]

Hi,

I'm looking for a expand/collapse functionality by showing/hiding objects and moving the objects. I don't want to use the Pivot chart.

All my values will be static and I need to show/hide ORANGE & PINEAPPLE on click of FRUITS by hiding the text box containing

ORANGE & PINEAPPLE and bringing the textbox object containing the Animals under fruits. Thank you

[vinieme12]

The approach will be similar to this

Partial Sums in straight table | Custom Labels in Pivot SubTotals

[vinieme12]

open the attached app, you can change the sortorder in the script  if you want the totals on the top of the subitems