本帖最后由 Anne01 于 2022-8-20 20:37 编辑
以这个网页中显示的透视表(https://demo.grapecity.com.cn/spreadjs/SpreadJSTutorial/features/pivot-table/overview/vue)为例,想获取透视表的数据,包括Totals,Date,季度
最终想要的数据格式如下:
- [
- {
- name: 'Alan',
- value: 811000,
- children:[
- {
- name:'季度1',
- value:110000
- },
- {
- name:'季度2',
- value:266000
- },
- {
- name:'季度3',
- value:250000
- },
- {
- name:'季度4',
- value:185000
- }
- ]
- },
- {
- name: 'Bob',
- value: 947000,
- children:[
- {
- name:'季度1',
- value:281000
- },
- {
- name:'季度2',
- value:161000
- },
- {
- name:'季度3',
- value:308000
- },
- {
- name:'季度4',
- value:197000
- }
- ]
- }
- ]
复制代码
|
|