<p>Hi,</p>
<p> </p>
<p>There seems to be several ways to achieve what I'm trying to do, but it's not entirely clear to me (I'm only just getting the hang of crosstabbing and dimensions)</p>
<p> </p>
<p>I have data laid out like so:</p>
<p> </p>
<p>Month 100 100-500 500-1000</p>
<p>Jan 342 423 234</p>
<p>Feb 133 234 123</p>
<p>Mar 533 344 231</p>
<p> </p>
<p>What I'm trying to get out of this dataset is a bar chart, with the columns as the X-Axis and the total value as the Y-Axis.</p>
<p> </p>
<p>Transposing the columns to rows is doable in a crosstab, but how can I do it for the dataset in order for the data to be used correctly in each axis of a bar chart?</p>
<p> </p>
<p>Thanks in advance</p>
