Today a colleague of mine Ernest Bosch has discovered the functionality of expanding Hierarchy column at desired level for all sections of a pivot table. In this post I will explain you how to do that.
In my example I take Products Hierarchical column, Department as a section and some measures.
But my requirement is to expand one level to all departments by default. It will be done using “Selection Steps Pane”.
Click on the “Then, New Step” under Products Hierarchy and then click on “Select Members”.
Till Next Time