How can to create a table for pivot table



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


1 Reply


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.