still happen in table view; all the other aggregation method don't seem to be correct either. they are MUCH larger numbers than what's on the current view.

This screenshot is now without any filter and two categories have incorrect subtotal.