i have a file with some pivot tables, some of which are static (rows don’t change over time) while others are dynamic (e.g. top 10 Clients). For static pivots i am fine adding a simple drop-down list to update DAX formulas, but I would avoid to create a VBA Macro to update dynamic pivots.
Is there a way to manage dinamic pivots (and the auto-sorting they guarantee) with DAX?
The question is referred to Top 10 Clients as they could change over time and I need to update the list of names.
Thank you for the support