Is there any way to have a cell as a click filter?
Example:ON the pivot, I have a row that displays categories and a column that displays quarters in the current year. I want to filter by category 1 and Q2. Clicking the corresponding cell for category 1 and Q2 applies the filter selection for category and quarter in year.
Please sign in to leave a comment.