Forum Discussion
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 with another database ( in another workbook as well)..
For example - I want my pivot table to look like this every time I need it
How can I do it automatically?
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.
