Forum Discussion
How can to create a table for pivot table
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=112310544159929632856&rtpof=true&sd=true
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.
2 Replies
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.
