How can to create a table for pivot table

[littlevillage]

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

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

[#2 · Accepted solution]

Hi@littlevillage, 

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.

[#3]

@dscheikey 

That's good idea.

Thank you so much