title: NetSuite saved search combining results to a single line per item
body: <p>I'm trying to create a saved search in <a href="http://www.netsuite.com" rel="nofollow noreferrer">NetSuite</a> that shows me the quantity of items available at each location.</p>
  
  <p>The formulas I'm using are</p>
  
  <p><code>"CASE WHEN {inventorylocation} = 'Location1' THEN {locationquantityonhand} ELSE 0 END"</code>, etc. I have entered a formula for each location.</p>
  
  <p>The result it's giving me is: </p>
  
  <h1>Item # | Location 1 | Location 2 | Location 3 | Location 4</h1>
  
  <h2>123456 |    10      |     0      |     0      |     0</h2>
  
  <h2>123456 |     0      |     0      |     5      |     0</h2>
  
  <h2>456789 |     0      |     3      |     0      |     0</h2>
  
  <h2>456789 |     0      |     0      |     0      |     7</h2>
  
  <p>Is there any way that I can get the saved search to show this instead?</p>
  
  <h1>Item # | Location 1 | Location 2 | Location 3 | Location 4</h1>
  
  <h2>123456 |   10       |     0      |      5     |     0</h2>
  
  <h2>456789 |    0       |     3      |      0     |     7</h2>
  
  <p>Thank you!</p>