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?
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!