How can to create a table for pivot table

Frequent Contributor


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


2 Replies
best response confirmed by small_village (Frequent Contributor)


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.



That's good idea.

Thank you so much