Can someone tell how to get iferror formula or what we can use to achieve this output sheet
from the Data sheet
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
And what about the % column? To show like an output sheet
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