jiaziforever
New Member
- Joined
- Jul 9, 2014
- Messages
- 2
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!
<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>
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>