Hello - I really like the way excel tables expand/contract based on the changing underlying data. I have pivot tables linked to an underlying query/data model table and slicers in place to easily manipulate the pivot report. However, I have additional reporting below the pivot table, and based on size of pivot, often run into the issue of overwriting existing data. However, with dynamically changing table sizes - I don't have the this problem. Is there a way to maintain a pivot table, but have the underlying range dynamically expand/contract.
2) is there a way to derive pivot table reporting within excel pivot tables - with same connection to data model?
thank you!
2) is there a way to derive pivot table reporting within excel pivot tables - with same connection to data model?
thank you!