Pivot Values to be auto populated in a table in Excel

[bhaskarnk]

Hi Team,
In the excel spreadsheet, I have a Pivot table where the values of the pivot table gets populated based on the value selected from a combo box. I need these auto populated values from pivot table to get dynamically populated in a different table mentioned in the same spreadsheet. Can you please help me to get the above desired result?

[bhaskarnk]

Attaching the sample file for your reference.

[xlnitwit]

Hi,

It looks as though the width of the pivot table is fixed so you can simply use a direct cell link such as =F4 in cell D29.

[bhaskarnk]

Hi,
Thank you for your response. The width of the pivot table is not fixed. Based on the release selected by the user, the width of the pivot changes. Currently, 17.3 has been selected. If you select the 17.1, it has only 3 rows and the below table also should populate only 3 rows with Total.
could you please help me? Thank you in advance.

[xlnitwit]

The width is the number of fields (columns) going across the pivot table. That is fixed.

If you do not wish to show 0 in the blank rows, simply use =IF(F4="","",F4)

[bhaskarnk]

But, the length of the pivot table varies based on the data. Does this solution hold good in this situation as well?

[bhaskarnk]

Thanks a lot. It worked. Highly Appreciated.