Gee, Excel Pivot Tables Who Knew?
This is Jan 19 data.
Seems like I can slice and dice my data however I like with Pivot Tables. I could also do this in FM reports of course, If I wanted. The problem here is that the transactions are sorted out of order which is irritating in Excel. Another reason I like FM.
Only need 7 fields to do the whole enchilada. If I knew how to sort properly, and total the times in Pivot tables, the data is there. It was sorted in FM.
There's a deeper level down, but that data looks a little personal, but it's there. Actually it goes two levels deeper. There's Cook, then Breakfast or lunch or whatever, and then drill down to what I made.
Or Read, then Books, Magazines, whatever, then drill down to the title.
It's also 1300 rows long if you want deal with all of it. but it is pretty amazing to look at if I do say so myself. 999 transaction for the month.