AnsweredAssumed Answered

excel like spreadsheet

Question asked by CStovin on Jun 5, 2013
Latest reply on Jun 7, 2013 by philmodjunk

Title

excel like spreadsheet

Post

     Is it possible to make a list view report that displays rows of fields and columns of fields?

     For the Rows I would like to have a list of customers

     For the columns I would like to have fields which display products.  I am thinking of having maybe 10-15 columns.  Each field would have an If type statement that if this column field which corresponds to the customer's Row, shows the amount out.

     In the attached image I would like the A column to populate with how ever many customers have items out that correspond with the Columns B,C,D,E,F....

     Row 1 Can be static.  I will only need certain reports on certain products which are out.  Perhaps if I need 10 products than I could create 10 fields that do a search for that specific item ?

     The information will be pulling from my work orders table which matching those particular items which are still out.  IF they are not out than a "0" will be in that cell.

     I'm a bit of a loss how to start this.

      

excel_example.jpg

Outcomes