Hi guys I'm new here hoping that someone can put me out of my misery!
I'm currently studying Excel 2013 Expert Skills book, Lesson 5-6: 'Apply a simple filter and sort to a pivot table'.
I use two computers at work, both with exactly the same installation of Excel. However, when trying to use the 'Row Labels' (and also 'column labels') filters within the pivot table I get two different results depending on which computer I am using (screenshots attached of the 'Transactions-4' sample file).
While one computer gives me check boxes to filter on, the other computer does not and the only way I have found to filter data on this computer is to use splicers, as the drop-down filter functionality rather bizarrely is not there. I am at a complete loss as to why this is. Maybe I have checked/unchecked a setting within Excel that I am not aware of?
Hopefully someone can point me in the right direction?