Please note javascript is required for full website functionality.
MVP

Blog

Final Friday Fix: June 2020 Challenge

26 June 2020

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel / Power BI fix”.  Challenge your office colleagues to see who can solve the puzzle quickest.  There are no prizes at this stage: you’re playing for bragging rights only!

 

You may have worked with PivotTables all of the time and believe you know them inside out.  However, there may be a small filtering option that you may not know of.  Do you know how to filter PivotTables based on values in all columns?

Applying filters on a table is relatively easy but are you able to achieve the same thing in a PivotTable?

The Challenge

This month’s challenge is to be able to filter on all columns in a PivotTable in Excel with no VBA, no megaformulae, and not in Power BI, but in Excel. 

 

Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog.  Have a great weekend in the meantime!

Newsletter