Please note javascript is required for full website functionality.


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!