Summarizing the data based on Group by and filtering out on certain condition

[madhurinani]

Hello,

I am trying to aggregate the above data by Group and sum of Number column and it should exclude the ESOP row when summarizing.

Output should be:

A new column to be created, and on row #5, the value would be 18/(5+6) i.e 18/11

and on Row #9, it would be 6/3

I tried using the summarize column but unable to filter to exclude the ESOP row when summarizing

the below pic shows the o/p expected

[LouisJ · Accepted solution]

You cannot directly make what you want in only a summerize block, but you can easily enough create a workaround by creating a new column for which "ESOP" and "_total" column are 0's, so that the summerize sums correctly for each Group, and then handle the calculation in a formula tool.

Let me know if you needed anything more specific,

LJ

[gabrielvilella]

Hi @madhurinani, let me know if this works for you.

[madhurinani]

@gabrielvilella @LouisJ : Both of your solutions worked for me.

Thank you!