title: Multiple select in Report Builder 3
body: <p>I have created a parameter that gives multiple options to the user:</p>
  
  <pre><code>Total Amount = Grand Total
  Region 1 = Total Amount for that Region
  Region 2 = Total Amount for that Region
  Region 3 = Total Amount for that Region
  Region 4 = Total Amount for that Region
  </code></pre>
  
  <p>Region 1 to 4 works great but when I select the Total Amount  I get the incorrect amount.</p>
  
  <p>Can some one tell me what I am doing wrong please.</p>
  
  <p>Main Dataset</p>
  
  <pre><code>     SELECT       OccupancyDetail.CalendarYear, OccupancyDetail.CalendarMonth, SUM(OccupancyDetail.No_of_Nights) AS No_of_Nights, 
                           SUM(OccupancyDetail.Capacity) AS Capacity,Site.BDM,Site.Region
  FROM            OccupancyDetail INNER JOIN
                           Site ON OccupancyDetail.Site_Skey = Site.Site_Skey
  
                           WHERE  (OccupancyDetail.ReferenceDate = convert(Date,getdate()))
  
                           AND
                           CASE WHEN @Time = 'YEAR' THEN CAST(CalendarYear as varchar(4)) else
                           CalendarMonth + ' ' + CAST(CalendarYear as varchar(4)) end in (@Dates)
  GROUP BY OccupancyDetail.ReferenceDate, OccupancyDetail.CalendarYear, OccupancyDetail.CalendarMonth,Site.BDM, Site.Region    
  Time Dataset
  
  select DateChoice FROM
  (select distinct CalendarYear, 1 as MonthNumber,CAST(CalendarYear as varchar(4)) as DateChoice from Time
  where @Time = 'YEAR'
  
  
  union all
  
  select Distinct CalendarYear, MonthNumber,CalendarMonth + ' ' + CAST(CalendarYear as varchar(4)) as DateChoice from Time where @Time = 'MONTH') as QRYDATA
  ORDER BY CalendarYear,MonthNumber
  </code></pre>
  
  <p>BDM Dataset</p>
  
  <pre><code>SELECT DISTINCT BDM
  FROM Site
  </code></pre>