Is it possible to apply a "rule" to an Excel Pivot Table filter?
I have three filters on my Pivot called 30day, 60day, and 90day. Each is populated with 'Y' or 'N'. If a user selects 60day = Y, then 30day and 90day must be reset to (All).... If the user selects 90day = Y, then 30day and 60day must be reset to (All).... etc. This way only ONE filter can be applied at a time for 30day, 60day, 90day.
I hope I explained this well. Thank you.