How do I create a summary report that displays the sum of transaction quantity grouped by part number without displaying multiple descriptions for same part?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

sample date would be:

part 1 - transQTY 2 - description "part 1 is awesome"

part 1 - transQTY 5 - description "part 1 is cool"

report results would display 

part 1 - sum transQTY 7 - description "Part 1 is awesome"

Photo of Brandon

Brandon

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,064 Points 20k badge 2x thumb
I would use script to do this. Also why is part 1 not reported as cool:

part 1 - sum transQTY 7 - description "Part 1 is awesome" and "part 1 is cool"