Pivot table is not getting refreshed on any selection of filters. it is kind of freezed. if anyone came across the same problem please help.
Make sure that the chat is not "Detached"
You can find this property under General Tab. Uncheck the "Detached"
Are you using the Set analysis in expression where you might have written something like this to exclude the selection.
Field1=, Field2 =