PIVOTS: Multiple columns to be shown as separate row labels

[gregz1234]

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:

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

 

[gregz1234]

I actual don't see anything to be subtotaled. The Months are totaled. The rows are totaled by the categories, so what Subtotal is missing?

So sorry all for the confusion, I meant I'm not seeing grand totals, by month. Sorry about the confusion there. Is there a way to populate this, at the bottom? I've tried several different formatting, and for now have left it to a manual calculation. If there is nothing I can do, leaving it as a manual calculation is no problem.

 

[SpillerBD]

Grand Totals are normally on by default. Check under the Design Ribbon in the Pivot Table Context Ribbon. There is a set of GrandTotal options.