Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The approach will be similar to this
Partial Sums in straight table | Custom Labels in Pivot SubTotals
open the attached app, you can change the sortorder in the script if you want the totals on the top of the subitems