Getting formula for desired format output

[Kiara16]

Can someone tell how to get iferror formula or what we can use to achieve this output sheet

from the Data sheet

[ChrisTX]

Try a Summarize tool with Action = Sum

But if your Subordinate Id column is a Numeric data type, and you want the word "Total" in that column, you'll need to change it to a String data type.   (use a Select tool)

Chris

[Kiara16]

And what about the % column? To show like an output sheet

[ChrisTX]

Use a Formula tool

Create new field "My Percentage".  Data type FixedDecimal 19.2

IF [April] = 0 or IsEmpty([April])

THEN 0            or THEN Null()

ELSE [May 2023] / [April]

ENDIF

Chris

[Kishori]

Check the attached flow for the answer to the above question.