- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
eliminate items that have too many blank entries
Hello everyone,
I am trying to eliminate "items" that have not been sold enough times in the year per a week basis.
Thus, I would need to some the total quantity sold in a year of that item. Then I would eliminate the item that was not sold enough.
i.e. I only want items that were sold more than 20 times. Only 13 hamburgers were sold, thus I want to eliminate them. However, 34 pizzas were sold thus I want to keep them.
Thanks in advance for the help!
Week number | quantity sold | item title |
1 | 5 | hamburger |
2 | 0 | hamburger |
3 | 7 | hamburger |
4 | 1 | hamburger |
1 | 20 | pizza |
2 | 6 | pizza |
3 | 7 | pizza |
4 | 1 | pizza |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
One of the more straight-forward ways of doign this is to create a filter measure e.g.
Then place it as a filter like this:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
If t is your table, the filtered table is
Filter(t,[Quantity] >20).
Best regards.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
01-13-2025 07:35 AM | |||
11-12-2024 09:41 AM | |||
12-22-2024 01:12 PM | |||
08-29-2024 06:31 PM | |||
11-20-2024 12:09 PM |
User | Count |
---|---|
19 | |
17 | |
14 | |
13 | |
11 |