excel like spreadsheet
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.