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.
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 %.
Thank you elsamuel and izaychik63!
@izaychik63 this works just fine.
I believe, it could be useful addition to have Group_% option in Group by node.
don’t think it is really for GroupBy node as its output is grouped while here this is not the case.
Well, it could be Group Statistics node calculating %, top-n, so on.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.