So, if the data already looks like a pivot table, we need to “unpivot” it, and put each sales amount on a separate row. You would have to create a calculated field to add all the month values together. The pivot table won’t be able to automatically calculate an annual total. When you build a pivot table from that data, there will be 12 different fields with sales amounts – one for each month.
It looks good on the worksheet, but won’t work well in a pivot table. Instead of having a separate row for each month’s sales, each row contains 12 months of sales data. If your data has a separate column for each month’s sales, it already looks like a pivot table report. Don’t miss out – it well be a few months before the course opens again! You’ll learn how to create awesome dashboards, quickly and efficiently, and you’ll pick up other key Excel skills too. Here’s what that means, and 2 quick ways to unpivot Excel data.įirst, a reminder that today, Thursday August 18th, is the last day to register for Mynda Treacy’s highly-rated Excel dashboard course. For example, if the data has a separate column for each month’s sales, that won’t work well in a pivot table. Before you can build a flexible pivot table, you might need to rearrange the data.
0 kommentar(er)
