comparison report

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered

I am interested in creating a report which will display the data as shown in the photo attached.This report would be used by our sourcing dept to do side-by-side comparisons between vendor quotes.

  • Suppliers shown in columns
  • price/lead time/UOM. etc listed in rows

How would I go about this without completely restructuring my app? Currently, by default Price/Lead time/UOM etc are set as the columns. This seems like an easy thing to accomplish, maybe its because its Friday I just can't figure it out.

Photo of mkosek

mkosek

  • 776 Points 500 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
I suggest that you transpose the rows and columns and use a simple table report.

Make a report of the different vendors (rows) and have the columns be the fields.
Photo of mkosek

mkosek

  • 776 Points 500 badge 2x thumb
Thanks for the suggestion. I will need to play around with this a bit more. I am not sure how I should go about transposing the rows and columns without reformatting my current setup. Since it's not critical, and only just a "nice to have" report, ill put it on the back burner for now.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
All I mean is to make a simple table report  where the rows are the various suppliers.  So it would like transposed from your image example.  ie tell your users to just suck it up and use the report of a report by vendor as opposed to the way they asked for it.