Recommended Pivot Table
Hi, I wanted to ask if there is any option to create my own format of Pivot table that I will be able to click on it and get a relevant table based on my needs.. I make the same table everyday but w...
Forum Discussion
Not sure I'm following all the details of what you're describing, but I wanted to suggest that you look into using some of the dynamic array functions--notably UNIQUE, FILTER and SORT--which can be used to create the same kind of display as that done "automatically" by the Pivot Table, but far more customized.