Grouping items in a report based on one or more restraints

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a single equipment schedule table that is being fed by tow other tables, Installations and New Stores

In this report each equipment line item is entered individually so order numbers and dates can be assigned to each one. The issue is building a report to group by store number and division.

I need the report to show two line items by store when the store has two pieces of identified equipment.

In this case if a store has Unit A it will also have Unit B and I need each of those pieces of equipment to be grouped and show up in a report filtered to location that have both pieces of equipment assigned to it.

I can get one or the other but not both. Basically I need an association of the two pieces of equipment. The logic does not seem to work when build the report

If I say all conditions are true...equipment description is this and this, the report is blank.
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb
Here is an example....I want the item in the report in the green box but not the singles
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
You would have to have a summary fields at the Store level to count the A's and Count the B's and then flag if the sore has both and then look up that flag down to the units table and use it as a report filter of just stores with both. 
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb
Thanks Mark!