How can to create a table for pivot table

Contributor

Hi,

In the table I want to get values from Pivot table, when the data is updated, the pivot table change but in the worksheet I need copy formula.
How can I update that with only refresh.?

Hope for your response

I have added an image and the link of the sample file below

Please have a look

Thank you

small_village_3-1659792869528.png

https://docs.google.com/spreadsheets/d/14rrdM1d42CCu7kXBej8jGIrOONjLIwXK/edit?usp=sharing&ouid=11231... 

1 Reply

Hi@small_village

I have built you a solution with functions: SORT(); FILTER(); UNIQUE(). With these you don't need a pivot table for your evaluation if you don't want one.

See if this is what you want.