I need to filter unwanted numbers from a pivot chart. I am looking for the ability to filter out data points which occur certain number of times in the data table. My goal is compare "Part" reoccurrences (which is tallied by "Count of NMN") month over month, and my boss may want to see everything that reoccurred more than once or more than twice. Looking at the attached graph, the single occurrence items clutter my chart and serve no purpose as I am evaluating reoccurrences.
Pre-filtering the data is not an option because future data may contain reoccurrences of the parts which now only have 1 instance.
Bookmarks