I have a somewhat large table (close to 1M rows) that I'm trying to analyze using a Pivot Table. The Row (Variable A, each value unique) is sorted and I have built functions to analyze the Value column (Variable B, each value unique). I need to only include rows from the original table where Variable C (each value unique) is "Greater Than" a certain value. I would love to be able to have multiple value based filters (D,etc).
Using the Filter field or a Slicer allows me to filter only by checking individual values, which doesn't really work with 400,000+ values needing to be filtered.
"Clarifying" example: Analyze the profitability (B) of each sales person, ranked by age (A), but first filter out everyone with less than 5 years of tenure (C). Additionally, filter out everyone shorter than 5 feet (D).
Using the Filter field or a Slicer allows me to filter only by checking individual values, which doesn't really work with 400,000+ values needing to be filtered.
"Clarifying" example: Analyze the profitability (B) of each sales person, ranked by age (A), but first filter out everyone with less than 5 years of tenure (C). Additionally, filter out everyone shorter than 5 feet (D).
