1 Reply Latest reply: Oct 28, 2013 1:58 PM by Gysbert Wassenaar RSS

    More than one field in multi box

      Hi Guys,


      I'm currently running some bar graphs on a sheet which have their data run off of one table within my script.


      I'm now adding some more bar graphs where the 2nd set of graphs have their data run off of another table.


      The 1st set of graphs uses a multi box (Servicer) to select specific data from within my 1st set of data.  The 2nd set of graphs also have the servicer details scripted under Servicer2.


      I want my current multi box to incorporate the Servicer2 data for the 2nd bar graphs.


      Instead of simply adding both Servicer and Servicer2 in the 'Fields Displayed in Multibox', is it possible to write an expression which lists all selections in the one drop-down?


      There are many common entries within both tables under Servicer and Servicer2, however it is not possible to join the tables without duplicating the numbers.