Tablix/ Matrix hiding header when showing details

• mailbox.jon

  SSC Enthusiast

  Points: 113

  More actions

  July 10, 2014 at 11:44 am

  #397039

  I have a matrix which has the details hidden and toggled by a textbox.

  When the details are hidden, it sums the column up, however there is no header.

  If I add a row to the group below the header it will repeat in each column when the details are shown.

  Is there anyway to only show the header text (Total) when details are hidden, and hide it when details are shown as below

  ie

  +Show Detail

  % Total

  ------------------------------------

  Cust 1 10 1000

  -Show Detail

  % 2012 2013 2014

  ---------------------------------------

  Cust 1 10 150 250 600

  Thanks

  Jon