O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with worksheet events and VBA

For the reporting scenario that was outlined in the Introduction to this chapter, the intent is to allow the user to click on a pivot table row item and then have this action create downstream activity affecting other elements on the worksheet. That is, when the user clicks on a category item in the pivot table (the pivot titled sales_by_cat_all), the bar chart showing year-on-year category sales will change to show the selected category.

This type of action may be achieved through various methods—the use of a Filter or Slicer connecting the two pivot tables immediately springs to mind. However, in doing this, the end user is still required to select something from the drop down (Filter) or Slicer. We want ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required