How to refresh pivot automatically based on filter

[sarat47]

Hello Everyone

In the attached sheet, I want to refresh pivot automatically when I want to select data with filter in sheet "Data"

e.g Sheet contain total of 22 records. I have created the pivot with it. Problem is that when I select value "sum" from period column, then the pivot data is not automatically populated.

Could you please help is there any dynamic approach for selection.

Thanks in advance