You can create a calculated field using a window_sum table calculation to get the comparison between the marks of eee and the other marks.
IF ATTR([Name]) = 'eee' THEN SUM([Marks]) END
//isolates the mark value for 'eee'
//uses window sum to repeat the mark value for 'eee' for each name row
IF SUM([Marks]) > [Calculation2] THEN 1 ELSE 0 END
//compares the mark value for 'eee' to other name values
I attached a sample workbook that uses these calculations and the sample data you provided. Let me know if this works for you!
benchmark.twbx 26.9 KB
Please find the below dashboard.
Hope this is what your looking for.
Please mark it as helpful if it helps you anyway or other.
forum1.twbx 19.9 KB
Thank You Sudhakar. It works for me.