Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Aug 06, 2022
Solved

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 fo...
  • dscheikey's avatar
    Aug 06, 2022

    Hilittlevillage

    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.

     

Resources