0 Replies Latest reply: Sep 7, 2011 8:30 AM by asnajim2000 RSS

    Create XLS table for multiple selection/tables in one sheet

      I have the 2 following questions for help



      I have a table of 5 fields of   "moving date, Area, City, country and the cost"


      I need to create an XLS file with the moving date, and showing the total of cost for each area, with 2 columns on the same sheet for the total cost of 2 specific cities in table, so my XLS should be as the following


      Date, total cost of area, total cost of City1, total cost of City 2


      Appreciate your help


      the 2nd question, is how to set a default value for the selection based on another field selection, for example


      I select a 'selection 1' from table 1, and I need automatically to set certain values from table 2 based on the earlier selction


      many thanks for support