Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again. If all else ...

5. In the Create Pivot Table dialog window, enter the current table–VIOLATIONS–in the Table Range field box. Excel displays the Pivot Table Fields list with a message helper box that says ...