I am already doing that, But what happens is user double click on product- XYZ from cross tab, than that product gets filtered. so user wants to avoid that part. Not filter value when they double click on product from crosstab.
I have another question, if you can help.
I have 2016 and 2017 but i want my reports on only 2017 data, I tried so many calculation for calculating current year but no success.(I can create parameter but its not permanent solution,)
For time being i have created set it is working but for future i want that date refresh with data so set will not help.
Could you please help me with that.