I have a pivot and a multibox in my report. There is column named as "Test/Control" in multibox as can be seen in the attachment. It has two values- 'Control' and 'Test'. I need a 2 sheet report where one sheet contains the pivot and multibox for 'Test' selection in one sheet and 'Control' in other sheet with same pivot and multibox structure. i.e segregating the report on the basis of two selections.
I would have done so: during the moving to a second sheet to change the selection value in the Test/Control via a macro. A macro to hang on the change active sheet.
