问题已解决
我这边数据透视表想保存这么多求和项数据,但是我这边也想把数据透视图里面求和项删掉,该怎么做
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/20/54/04_avatar_middle.jpg?t=1651203228)
你好,可以把“求和项”替换成空值,因为不能字段名相同,可以把“求和项”替换成空格。
2020 07/22 10:27
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784974 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/22 10:34
老师我想你误会我的意思了
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784974 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/22 10:35
我说的是项目
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784974 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/22 10:35
我想保存表格的所以工资总额
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784974 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/22 10:35
等其他的
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784974 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/22 10:36
但是在数据透视图不想要怎么多
![](https://member.chinaacc.com/homes/resources/images/home/avatar/4.jpg)
84784974 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2020 07/22 10:36
数据透视表还可以筛选
![](https://pic1.acc5.cn/009/20/54/04_avatar_middle.jpg?t=1651203228)
方老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2020 07/22 10:57
不好意思,是我理解错了,数据透视图的数据源好像是改不了的。你可以做两个透视表,一个专门用来生成透视图。