Split categories not in csv export

Just realised that when I split categories, this isn’t reflected in my csv export. The full amount is just recorded against one of the categories. Intensely irritating and really negates the point of having them for me. Is this a bug or by design?

It’s split in column P.

Thank you