在数据透视表的"∑值"值标签中拆分项目 [英] Split items in '∑ Values' value label of pivot table

问题描述

在"∑值标签"中具有多个项目的数据透视表

有多个主题标记，总计为(a)结果(b)目标和(c)结果的差异.
将这3个聚合值放在数据透视表的"∑值"值标签中. 如图所示，数据显示为组(a)，然后是组(b)，然后是组(c).
我想将数据显示为group-(a1)/group-(b1)/group-(c1)/group-(a2)/group-(b2)/group-(c2)
即所有一个主题，[说英语](a)将结果(b)目标和(c)差异相加，然后是下一个主题[说数学].
我期望的结果在图像中标记为黄色. 你的帮助！会帮助我的.谢谢！

There are multiple subject marks aggregated as (a)Result (b)Goal and (c)Difference of Result.
These 3 aggregation are put in '∑ Values' values label of pivot. As shown in image data shows as group-(a) followed by group-(b) followed by group-(c).
I would like to show data as group-(a1)/group-(b1)/group-(c1)/group-(a2)/group-(b2)/group-(c2)
i.e. All one subject, [say English] (a)Result (b)Goal and (c)Difference together followed by next subject [say Maths].
My desired result is marked as Yellow in the image. Your Help! will help me. Thanks!

推荐答案

转到数据透视表"选项->显示"-> [选择]经典数据透视表布局(启用在网格中拖动字段)
此选项允许自定义字段布局

Go to Pivot tabel options-->Display-->[select] Classic PivotTable layout(enables dragging of fields in the grid)
This option allows custom field layout

这篇关于在数据透视表的"∑值"值标签中拆分项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！