Percent of Row Total

Hi everybody, I am attaching a workflow that calculates the percentage of each row total after doing a pivot table. I find this useful as the Excel Pivot Table includes this option, which can also be added into the pivot node.

The following link shows exactly what I am talking about

% of Row Total

The file was uploaded in this link Workflow

Regards

3 Likes

Hi mauuuuu5,

Thank you for your suggestion for improvement.

However with the new Math Formula (Multi Column) node you can do it in one step, calculating the sum of two columns in the same Math Formula (Multi Column) node.

Best,
Anna

Anna, I believe mauuuuu5 made a great proposal. If you have more than one group it nice to have a line % to the group.

Yes, what I aim is that the pivot table node provide us the same options as Excel does.

Cheers

1 Like

For some reason the workflow is not available so I am attaching it

Cheers
Percent of Row Total.knwf (21.3 KB)

3 Likes

mauuuu5 thanks for sharing. this was what i was trying to fix at this point and find your recommendation very useful.