1 Reply Latest reply on May 11, 2012 8:52 AM by Tracy Rodgers

    Adding (sub)totals in between columns

    Alvin Yeap

      Hi Everyone,

       

      I'm just wondering if there's an easy way to add subtotal rows in between a dimension split across columns. It's a bit difficult to describe what I'm after in words, but the attached workbook should show clearly what I'm after.

       

      I could create a separate calculated field for each column (3M, Acco, etc) and create a Total calculated field as well and put them on a Measure Values shelf but that doesn't allow me to format the Total columns in bold.

       

      Any pointers would be much appreciated.


      Thanks in advance,

      Alvin.