SAP Business Objects Cross Table Data Duplication
<p>I'm using Business Objects to construct a simple report on whether a unit is on or off for a given day. When constructing a vertical table, the data is correct and looks like such:</p>

<pre>
    Unit ID | Status | Date
    1       | On     | 2016-09-10
    1       | On     | 2016-09-11
    1       | Off    | 2016-09-12
    2       | Off    | 2016-09-10
    2       | Off    | 2016-09-11
    2       | On     | 2016-09-12
</pre>

<p>However the cross table I've created, with columns of "date" and rows of "Unit ID" is duplicating Unit ID and having an entire row of 'On' followed by an entire row of 'Off' like:</p>

<pre>
    ____| 2016-09-10 | 2016-09-11 | 2016-09-12
    1   | On         | On         | On
    1   | Off        | Off        | Off
    2   | On         | On         | On
    2   | Off        | Off        | Off
</pre>

<p>instead of what it should be as:</p>

<pre>
    ____| 2016-09-10 | 2016-09-11 | 2016-09-12
    1   | On         | On         | Off
    2   | Off        | Off        | On
</pre>

<p>Any suggestions as to why it's doing this? The table isn't particularly useful if it has these duplicate rows and I can't understand why it's resulting in this odd table.</p>