Pivoting: How to get Percent for a Groups

Hello everyone,

I’m trying to find a way to get something like subtotals in percent (from Excel Pivot table) in Knime.

Here is my example:
I’m not able to get the yellow column calculated in Knime. I want to have the percent of the Product Family and Product combination.

image

Any help would be appreciated.

Thanks,
Sven

Use Group by node to get group total.
Join back to original table on group column adding total column
Use Math Formula node to calculate %.

2 Likes

Thank you elsamuel and izaychik63!

@izaychik63 this works just fine.

1 Like

I believe, it could be useful addition to have Group_% option in Group by node.

1 Like

Hi @izaychik63,

don’t think it is really for GroupBy node as its output is grouped while here this is not the case.

Br,
Ivan

Well, it could be Group Statistics node calculating %, top-n, so on.

2 Likes

Hi @izaychik63,

maybe it could.

Br,
Ivan

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.