Dynamic Pivot Help

[kishoremcp]

Hi, I have a sheet which is a database from an existing connection in file. Range is from A to W in which rows are dynamic.
I want a filed which should calculate from column K to O in the pivot and a dynamic pivot as attached image where sum is a filed where it will calculate the sum of column K to O.

Please help me with a dynamic pivot which should change the data up on refreshing the database and the pivot also.

I hope I am clear.

Thanks in advance.