subgroup in matrix and grand total

• al.yukhvidin

  Mr or Mrs. 500

  Points: 534

  More actions

  April 29, 2016 at 10:21 am

  #310205

  Hello,

  I'm very new former Crystal expert needed moved to SSRS 2012. And, here you go in the my very firs project already having problem.

  I need create cross-tab with the group and sub-group in the rows and age range in columns to calculate number of clients visits base on their ages.

  Have no problem to create simple matrix with one row field and one column field, but can't add other level in row and grand totals for rows and columns.

  Please help.

  Al.

• PB_BI

  SSCoach

  Points: 17463

  More actions

  May 3, 2016 at 1:37 am

  #1876160

  https://msdn.microsoft.com/en-gb/library/ms170712.aspx

  ---

  I'm on LinkedIn

• al.yukhvidin

  Mr or Mrs. 500

  Points: 534

  More actions

  May 3, 2016 at 8:28 am

  #1876254

  Ten Centuries,

  Thank you, but this article about Totals/Grand Totals in tables. My question was about Matrix.

  Al.

• PB_BI

  SSCoach

  Points: 17463

  More actions

  May 3, 2016 at 8:38 am

  #1876257

  al.yukhvidin (5/3/2016)

  ---

  Ten Centuries,

  Thank you, but this article about Totals/Grand Totals in tables. My question was about Matrix.

  Al.

  The same process applies to both matrices and tables in SSRS.

  ---

  I'm on LinkedIn

• al.yukhvidin

  Mr or Mrs. 500

  Points: 534

  More actions

  May 3, 2016 at 9:04 am

  #1876270

  Thanks again. I'll try.

• al.yukhvidin

  Mr or Mrs. 500

  Points: 534

  More actions

  May 3, 2016 at 9:16 am

  #1876274

  Works! Thanks again!

  Al.