How do I create a 2 constraints on 2 things?

mgray · June 24, 2019, 7:58pm

I have 1) Projects and they have 2) Bids. Each are different things in the data based.

I need to filter out Bids by the user + filter out Projects in the bidding stage to calculate the total. For example, User #1 would have $3,000 of projects bidding & User 2 would have $4,000 of actively bidding projects.

How do I make this work?

PROJECT 1		PROJECT 2		PROJECT 3	
PROJECT STAGE	BID	PROJECT STAGE	BID	PROJECT STAGE	BID

USER 1 Bidding $1,000.00 Bidding $2,000.00 Won $3,000.00
USER 2 Bidding $1,000.00 Bidding $3,000.00 Lost $5,000.00

mgray · June 24, 2019, 8:10pm

Here’s how I did it:

Use constraint to show all bids by User.
Use advanced filter to only show Projects with a “bidding” status.

Everything looks to be correct BUT it’s adding all the bids the User has ever submitted. It never filters out only the ones “bidding”.