title: SSRS reporting with multiple values for date row in dataset
body: <p>So I am building a SSRS report that uses multiple datasets(at the moment, for testing), but the main dataset "getData" houses the original query. The problem I am running into is that I seem to be at a lose on how to query through the dataset to grab the data I want for the specific date, title and the value corresponding the that date and title. Here are pictures of most of what I am trying to use. <a href="https://i.stack.imgur.com/ohE6R.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ohE6R.png" alt="DatasetQueryFields"></a></p>
  
  <p><a href="https://i.stack.imgur.com/VcMaF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VcMaF.png" alt="DataQuery"></a></p>
  
  <p><a href="https://i.stack.imgur.com/Y3oC2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y3oC2.png" alt="datasetQueryresults"></a></p>
  
  <p><a href="https://i.stack.imgur.com/gd4NY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gd4NY.png" alt="SSRS format"></a></p>
  
  <p>So as you can see, If I want the value for Customer Suppot on  Thursday before the 09-12-2015 then I want to extract just that value. How do I approach this? I built another dataset which was using the same query as the dataset above but I added a filter to it for just Thursday before the 9-12-2015. But I seem to only hit the first values of that dataset and the Lookup statement just gives me empty cell. So I am a lost here. Please hints and help will be greatly appreciated. </p>