Wardrobe Spreadsheet Analysis: Simple Metrics
Last time we talked about starting to do some simple analysis using tools built in to Google Sheets (and Excel) . Now that we're familiar with our friend the pivot table, we can do more. We're not going to go over everything you could possibly do with your wardrobe and a pivot table, instead we're going to go over a few specific things as a jumping off point to get our feet wet. Things we'll do in this post: Sums of each brand charts Most expensive main piece most expensive JSK, OP, Skirt Breakdown of types for each brand Let's get started Total spent per brand This is pretty similar to the "Average price per brand" that we did in the last post. What we're going to do now is set it up and add a chart to it so we can visualize the sums. Here is my result: Here is my pivot table editor: Add one row for "Brand" Add one value for "Price", and summarize by SUM Add a filter to filter out any...