Excel — Pivot tables 5: “Weird behavior”
Channel: Susanne Flach
Date: 2020-12-14

If you are new to pivot tables, it is often difficult to know which variables/columns go where and this can lead to apparently weird behavior. This clip discusses some of the most common issues that beginners come across, e.g., getting a sum when you want a count and a weirdly high number of columns in the pivot table.

For data sets & a complete tutorial list see https://sfla.ch/tutorials/excel

The Excel tutorial playlist: https://www.youtube.com/playlist?list=PLIZN-827NSINRq4EtjXeoPlh-62akkXWa

Leave problems with the clip contents or suggestions for new clips in the columns below.