Background Learned a new Excel keyboard shortcut but it doesn’t work on your computer? Or the shortcut used to work fine but it suddenly stops working? That could make someone really frustrated. Let’s say for example Ctrl Shift 9 /
This is because you didn’t add the source data of the pivot table to the data model. Checking the box “Add this data to the data model” enables you to turn on distinct count feature in Excel pivot table.