title: How to create a parameter for multiple columns in SSRS
body: <p>I have created a report, the columns are like this below:</p>
  
  <pre><code>Date        
  Sponsorsource    
  totaldeal   
  totalnewcardeal    
  totalusedcardeal
  </code></pre>
  
  <p>Now, I want to create a parameter "dealtype". 
  The Parameter dealtype has 3 labels: </p>
  
  <pre><code>totaldeal, 
  totalnewcardeal, 
  totalusedcardeal
  </code></pre>
  
  <p>If I select "totaldeal" in parameter "dealtype, the report will show like this:</p>
  
  <pre><code>Date        
  Sponsorsource    
  totaldeal   
  </code></pre>
  
  <p>However, when I created parameter "dealtype", I added 3 lables and values of totaldeal, totalusedcarsdeal, totalnewcarsdeal in section of "specify value''</p>
  
  <p>When I preview the report, I select "totaldeal" in parameter "dealtype", The column and values of totalusedcarsdeal and totalnewcarsdeal still showed up, like this: </p>
  
  <pre><code>Parameter dealtype= totaldeal
  Report:
  Date        
  Sponsorsource    
  totaldeal   
  totalnewcardeal    
  totalusedcardeal
  </code></pre>
  
  <p>Can anyone help me one it? Thank you very much!!</p>