Hello all,
This certainly feels like a silly question, and I'm certain there's a work around in powerpivot, however for nonPPV/Excel 2010, does anyone know a way to display dollumn values seperately as rows?
I don't believe this is possible, however I would be remiss if I didn't ask.
The current Table sample looks like:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
When the years (column) are moved to column labels, the Duty and EV lines blow out the table, etc.
I ideally would like the PT to show as:
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
I've been play around with few different ideas and nothing has worked. While certainly it wouldn't be the worst thing leave the table as-is, it would make reporting a lot easier if it could be formatted as below.
Thanks in advance!!
-Greg
This certainly feels like a silly question, and I'm certain there's a work around in powerpivot, however for nonPPV/Excel 2010, does anyone know a way to display dollumn values seperately as rows?
I don't believe this is possible, however I would be remiss if I didn't ask.
The current Table sample looks like:
Year | Duty TTL | EV TTL |
2009 | 2 | 20 |
2010 | 600 | 63 |
2015 | 10800 | 818 |
Grand Total | 11402 | 901 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
When the years (column) are moved to column labels, the Duty and EV lines blow out the table, etc.
I ideally would like the PT to show as:
2009 | 2010 | 2015 | Grand Total | |
Duty TTL | 2 | 600 | 10800 | 11402 |
EV TTL | 20 | 63 | 818 | 901 |
Grand Total | 22 | 663 | 11618 | 12303 |
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
I've been play around with few different ideas and nothing has worked. While certainly it wouldn't be the worst thing leave the table as-is, it would make reporting a lot easier if it could be formatted as below.
Thanks in advance!!
-Greg