Gather sum of amount spent or earned in three categories over 6 months

there is probably an easier way but you could add notes or tags to the things you want to track (via autocat?)

then @yossiea 's transaction tracker will make your task so quick and easy you will not believe it.