14 Replies Latest reply on Nov 8, 2013 4:04 PM by Matt Lutton

    Crosstab Row Grand Total Retains Month breakout

    Ken Gamble

      I need to display a Crosstab with a dimension in the row and dimension in the column broken out by month - and include a grand total for the column dimension - still broken out by Month.  

       

      For example - if I want to show products by Region per Month - with a total for All Regions at the right - but still by month (shaded in Yellow below) - I can't figure out what I'm missing to construct the 'yellow' section.

       

       

      EastWestTOTAL
      PRODUCTJanFebMarJanFebMarJanFebMar
      AAA123456579
      BBB24681012101418
      TOTAL369121518152127