Goodbye Excel Groupings, Hello Toggle Buttons: A PAfE Win for Web Reports

June 23, 2026

Have you ever been in a situation where you have a very wide Excel report and want to allow your users to minimize the columns that appear? If so, one of the options at your disposal is the ability to group columns. This allows users to easily show or hide columns, thereby allowing them to see additional columns on the screen.

Have you ever been in the same situation when creating a PAfE report that you want to publish on the web? If so, you quickly realized that Excel’s grouping functionality does not flow through into your PAW environment.

But have no fear, IBM has come to the rescue! Version 2.1.19 of PAfE includes a new feature which allows action buttons to toggle your rows and columns. The feature includes the ability to:

Define either rows or columns for toggling
Define the specific rows or columns to be toggled
Recalculate or rebuild the sheet after toggling

To enable the feature, simply select the option for “Toggle range” when creating an action button.

Once created, action button can be used like Excel groupings … but without the added rows on top (e.g., the “plus” symbols”). In addition, the button will work in both PAfE and PAW.

Revelwood is an IBM Gold Business Partner with more than 30 years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. We focus on solutions for the Office of Finance and have partnered with clients of all sizes across all industries to optimize, enhance and expand their use of Planning Analytics. Revelwood’s Planning Analytics team consists of PA experts with decades of experience, and we have been recognized via awards including IBM Champion status.

Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.

Author

Lee Lazarow

View all posts