Pivoting: How to get Percent for a Groups

KNIME Analytics Platform
#1

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

#3

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
#4

Thank you elsamuel and izaychik63!

@izaychik63 this works just fine.

1 Like
#5

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

1 Like
#6

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

#7

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

2 Likes
#8

Hi @izaychik63,

maybe it could.

Br,
Ivan

1 Like
#9

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