Percentage of Parent Row Total or percentage of Parent Column Total in new function pivot

Question

Marco Riani 2023-2-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1913240-percentage-of-parent-row-total-or-percentage-of-parent-column-total-in-new-function-pivot

评论： Marco Riani 2023-3-30

I wonder if it is possible in the new function pivot (MATLAB prerelease 2023A) to produce a pivot table which shows values in percentage of Parent Row Total or percentage of Parent Column Total.

So far it seems to me there is just the possibility of specifying "percentage" that is percentage with respect to grand total and it is not clear to me whether it is possibile to obtain percentages of Parent Row (Column) Total with a function handle.

Of course I can first obtain the initial pivot with the raw data and then with one line of code to obtain the percentage of Parent Row (Column), however it is interesting to know whether this can be done directly with a call to pivot.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Pratheek 2023-3-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1913240-percentage-of-parent-row-total-or-percentage-of-parent-column-total-in-new-function-pivot#answer_1204714

Based on the documentation of the new pivot function in MATLAB prerelease 2023a, it seems that it does not have built-in support for calculating percentages of parent row or column total.

Summarize tabular data in pivoted table - MATLAB pivot (mathworks.com)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Marco Riani 2023-3-30

Yes, I fully agree. The question is whether it is possible to obtain them with a function handle in option 'Method'. In my opinion it is not possible. Could you please confirm it?

请先登录，再进行评论。