I have pivot table with a vertical product dimension and horizontal period dimension. Is there a way to collapse/hide/remove rows and columns using a conditional expression? The expression is used to look for exceptions, values greater than x% and values less than y%.
I have looked the forums but not found my answer. As a starting point I looked at IF and attached is an example.