Calculating Percentages in Pivot Table

KNIME Analytics Platform
1

Hi

I have the following extract from a pivot table and I would like to calculate the percentages for each row:

image

However, the denominator in the percentage calculation needs to be the total of each type of payment method so I can’t just use the COL_SUM function in the Math Formula (Multi Column) node (e.g. for “Conproc” denominator would be (2+5+5+181+174+0 = 367) and for “Manual” it would be (7+1+0+52+17+0 = 77).

The final table would look something like this:

image

NOTE: I have the denominator totals from another pivot table but I can’t think of a way of using them with the pivot extract above.

Is there a way of doing this?

Thanks
Chris

2

hi fostc80857 ,
my approach, splitting conproc/manual …
[KNIME_split-calc-MM.knwf|attachment]
KNIME_split-calc-MM.knwf (109.1 KB)
image
rgds

1 Like
3

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