![]() This approach is described in many blogs and/or forum entries: A very important requirement for the customer was that whenever one of those filters is changed, all other PivotTables in the workbook should also be synchronized and filtered accordingly.Ī common solution for this problem is to use a VBA-Macro that pushes changes in the filter across all PivotTables. ![]() For example Year, Period, Organisation and so on. Most of the PivotTables had several filters in common. The final workbook contained 10+ worksheets each with one or more PivotTables querying the PowerPivot model. ![]() I recently did a workshop with one of my customers where we were building a PowerPivot model which was later used for several reports.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |