I am displaying data in a straight table. I want to display the 'Mode' (most frequent occurrence) in one column and then the count or number of times that mode value has occurred in the next column.
I have the mode, but I can't figure out how to calculate the count of the mode value... any help would be greatly appreciated. Please see a sample data set attached. You can see a couple of my attempts to calculate the mode within the straight table.
For example, in the sample data set I provided, for vehicle 2017 V7 the most frequent complaint (or mode) is 'air bag' and this complaint occurred 5 times. So this 2016 V7 row should say '5' in the Count of Mode column.