Hi! I was looking for the same thing and just typed out all the sub and top categories for myself. See attached. This should be most of them. Any weird subcategory you see was added by me and I forgot to delete before posting.
Happy pivoting :)
---
HOW TO GET YOUR TRANSACTIONS TO LOOK AWESOME:
- Download all transactions from Mint
- Download the Top Categories attachment (in this reply) and include any subcategories you have added manually; move it into the Mint Transx file as tab "Top Categories"
- In the transactions tab, add three columns (Month, Year, Top Category) and drag the formula down for all your transactions
- Month: =MONTH(D2)
- Year: =YEAR(D2)
- Category: =VLOOKUP(I2,'Top Categories'!A:B,2,FALSE)
Highlight data and insert pivot tableTo get your transaction data to look like the Mint "Trends" page, pivot as follows:
- I want to see ALL my 2015 transactions and the way "Trends" shows my pie by top category
- Report Filter: Year = 2015
- Column Label: Transaction Type
- Row Labels: Top Category, Category
- NOTE: I noticed that with all the top categories, my total spend did not equal the "Trends" total; you will need to UNSELECT "Income", "Investments", and "Transfer"
- Values: (Sum of) Amounts