Multiple Formats in a Single Column with Calculating Totals

Hi all,    I recently needed to have multiple formats in a single field where the totals and sub totals would calculate within a matrix, I couldn't find anything that matched exactly what I needed ...