how to show specific rows based on specific field in pivot table

[jiaziforever]

Hello everyone, here is my question:

For below pivot table, I want to show: row FC1 for column 1, 2, 3. row FC3 for column 4, 5, 6. row FC6 for column 7,8,9. So basically only yellow cells. And I want to have these yellow cells to be on same row(to be named as FC). How to do it just in pivot(i.e., without changing source data)?


Thank you in advance!

		Year	Values
		2013
Items2	Items	1	2	3	4	5	6	7	8	9	10	11	12
ACT		3,888.1	4,598.0	1,493.1	1,937.9	(5,388.9)	3,989.6	(2,167.2)	3,158.6	(8,494.9)	(6,502.9)	15,075.3	(6,454.2)
FC1		644.9	571.8	559.9	0.0	0.0	(223.5)	0.0	0.0	(2,777.3)	0.0	0.0	(765.4)
FC3		3,888.1	4,598.0	3,659.2	(827.4)	(828.7)	(830.0)	0.0	0.0	(5,047.8)	0.0	0.0	(3,007.5)
FC6		3,888.1	4,598.0	1,493.1	1,937.9	(5,388.9)	(4,383.8)	(1,515.9)	(2,329.0)	(983.2)	0.0	0.0	1,326.9
FC9		3,888.1	4,598.0	1,493.1	1,937.9	(5,388.9)	3,989.6	(2,167.2)	3,158.6	(11,520.8)	(5,659.5)	14,302.0	(10,191.7)

<colgroup><col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <col style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;" width="58"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706; mso-outline-level: 1;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706; mso-outline-level: 1;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706; mso-outline-level: 1;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706; mso-outline-level: 1;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706; mso-outline-level: 1;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706; mso-outline-level: 1;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706;" span="2" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706; mso-outline-level: 1;" width="74"> <col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2706; mso-outline-level: 1;" width="74"> <tbody>
</tbody>

 

[Andrew Poulsom]

Welcome to MrExcel.

To do that you would need to move the columns to the row area.

 

[jiaziforever]

What I want to do is only show row FC1 amount under column 1 to 3 (so only value 466.9, 571.8, 559.9), and FC3 amount under column 4 to 6 ((827.4),(828.7), (830.0)), FC6 amount under column 7 to 9 ((1,515.9), (2,329.0), (983.2)), same logic for column 10 to 12. And I want these amount to be shown on one row.

 

[Andrew Poulsom]

That's not possible, sorry.