Pivoting: How to get Percent for a Groups

svensch · February 13, 2020, 3:04pm

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.

Any help would be appreciated.

Thanks,
Sven

izaychik63 · February 13, 2020, 4:08pm

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 %.

svensch · February 13, 2020, 6:21pm

Thank you elsamuel and izaychik63!

@izaychik63 this works just fine.

izaychik63 · February 13, 2020, 7:42pm

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

ipazin · February 14, 2020, 9:40am

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

izaychik63 · February 14, 2020, 1:00pm

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

ipazin · February 14, 2020, 1:52pm

Hi @izaychik63,

maybe it could.

Br,
Ivan