It is possible to have possibility to click on pivot row cell / singleton and to have pop-uped autofiltered report based on clicked cell? Which combined functionality could I use?
I don't know about pop-up, but you can certainly do that as a drill through