Resize table based on pivot table

[sharshra]

I have a table which reads values in a pivot table & do some calculations. The pivot table keeps changing based on the data it contains. I want the table also to resize based on pivot table. Any suggestions please?

For example, consider the following -
- 10th Dec - Pivot table-1 has 100 rows - Table-1 is created with 100 rows corresponding to 100 rows in pivot table-1.
- 11th Dec - Pivot table-1 has 40 rows - I want Table-1 also to be updated to 40 rows corresponding to 40 rows in pivot table-1. But, now table-1 still contains 100 rows based on how it was created on 10th Dec.

 

[GraH]

Why? Can't you build the result you want with the pivot directly?
You could also use a Power Query, directly on the raw data, to create a resized table based.

 

[sharshra]

I have to use the table structure given by others & constrained to update table based on pivot table. Yes, there are better options, but in this instance I would like to know how resize table based on pivot table.