Unable to find percentage of two values stored in two separate fieldnames

[sh254087]

I'm facing a weird issue. I'm not able to calculate percentage value when I use two variables/fields.

I have a lookup file which looks something like - 

sl,Service,x_value

1,X,0.211

2,other,0.190

3,Y,0

4,X,0.200

5,other,0.220

I'm trying to get two columns in my resultant table to show total by service and percentage by service, respectively.
I've tried this - 

percentage needs to be calculated using 2 fields whereas perc1 and perc2 are substituted with one of those two field values.

While the perc1 and perc2 gets processed and displayed, percentage doesn't show up.

I'm not sure what is that I'm doing wrong here. Can somebody please help?

[ITWhisperer · Accepted solution]

| inputlookup xyz.csv
| stats sum(x_value) as TotalMain by Service
| eventstats sum(TotalMain) as Total
| eval percentage=100*TotalMain/Total

[sh254087]

This just worked perfectly. Thank you very much, @ITWhisperer .

I had never used eventstats practically. Will check more on it.