Usually, things go smoothly when you when you try to create a pivot table. In the screen shot shown below, there’s a list of sales orders, and we’d like to create a pivot table from that data. Everything looks okay in the source data, but when you try to insert a pivot table, a confusing [...]

In a comment on this blog, someone asked how to create two pivot tables on the same Excel worksheet. Shown below is a worksheet named Pivot_Reports, with a pivot table on it, based on the data on the Sales_East sheet. We’ll add another pivot table to the Pivot_Reports sheet, based on data on the Sales_North [...]