Matrix Rows Issue

• Nemo - 4828

  SSC Eights!

  Points: 992

  More actions

  September 22, 2009 at 9:43 am

  #204885

  Hi Members,

  I have a report which should look like this..

  AccountCode/AccountName-------Month

  ----------------------------------Month1------Month2-----Month3 ........... --------GrandTotal

  + Account Code-------------------Count1-------Count2-----Count3.............

  ----------AccountName-----------Count1-------Count2-----Count3.............

  GrandTotal

  The account code has count of data of all the accountnames for that particular Accountcode.Each accountname has an individual count again.

  Am using a matrix for this. When i use the matrix i get the account name as a seperate row but not as a toggled item for accountcode under the same row.

  I hope you understood the issue....Please suggest..

  Thanks,

  Nemo

• bendy1999

  SSC Eights!

  Points: 932

  More actions

  September 24, 2009 at 6:45 am

  #1057974

  Hi Nemo,

  if I understand you right, then the AccountCode can hold multiple AccountNames. In matrix, you can add groupings on both Columns and Rows.

  Could you provide some Sample-data?