Calculate a percentage for each category from a total column

[guigui17]

Dear all,

I struggling with this one. Here is my scenario

Using the Summarize tool, I have established how much costs have been incurred by each Metric time category.
I want now to know what is the % of each category versus the total of Sum_ Cost per activity.

In a second step, I want to allocate the % obtained on the Metric Time category called “other” to All the other categories.

I have tried to use the Multi Row formula tool , but this has been a great success yet.

If you know how i should start, this would be great.

Thanks a lot for your support,

Guigui

[messi007]

@guigui17,

Could you share the data zip of the workflow using the export option below it will help as to get the data.

Best Regards,

[guigui17]

Hi Messi,

thanks for the tip.

here below the exported workflow

[messi007 · Accepted solution]

@guigui17,

Please see below:

Attached the workflow,

Hope that helps!

Regards,