svensch
February 13, 2020, 3:04pm
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.
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
svensch
February 13, 2020, 6:21pm
4
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
ipazin
February 14, 2020, 9:40am
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
Well, it could be Group Statistics node calculating %, top-n, so on.
2 Likes
system
Closed
February 21, 2020, 1:53pm
9
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.