Limit Braker
New Member
- Joined
- Jun 17, 2020
- Messages
- 13
- Office Version
- 365
- 2019
- Platform
- Windows
Hi guys,
Im trying to filter to a table some promotions (given that our ERP doesnt have mix and match codes to filter from)
The database im extracting from looks like this:
and the table im filtering it to looks like this:
The colors match the products of the promotion.
So for example.
What if i want to know how many promo2 did store1 sell? witht that given price? (promo2 total price is 25 bucks, how do i sum the values on different rows to add up that criteria and at the same time fulfill all the rest of criterias?)
I did it with Countifs filtering the products from a pivottable so that i can get the total price per ticket.
But can i do it from a formula itself?
Please any suggestions
Im trying to filter to a table some promotions (given that our ERP doesnt have mix and match codes to filter from)
The database im extracting from looks like this:
and the table im filtering it to looks like this:
The colors match the products of the promotion.
So for example.
What if i want to know how many promo2 did store1 sell? witht that given price? (promo2 total price is 25 bucks, how do i sum the values on different rows to add up that criteria and at the same time fulfill all the rest of criterias?)
I did it with Countifs filtering the products from a pivottable so that i can get the total price per ticket.
But can i do it from a formula itself?
Please any suggestions