title: Cognos Analytics: Split variable into two by month
body: <p>In Cognos Analytics I have a dataset containing rows with data (used disk space in MB), with each row being either February or June. Because I want to compare the two months, I want to create two new variables: one with the February data and one with the June data.
  In the Query editor I've tried: count (MB) when month = 'February'. This, and a couple of other entries don't work.
  I wonder if anyone can provide me the right line of code.</p>
  <p>Thanks in advance!</p>