Trying to write expressions but getting error

[#1]

I am trying to count the employee, who are above or below the median salary.

The expressions I am using is as follows:

Count({<[CTC]={">="} Median({<[CTC]>} [Employee])

Please help.

[sunny_talwar]

Not sure what is M_Grade, but the sample from other post seems to not have that field. For total, it seems to be working

[#3]

M_Grade = Job in original file. M trying to explain you what I am looking for with the dummy data reference.

Average of total data = 73919, Below average Job "A" count = 147........& expression working fine to get this data and so on....

But what I am looking for is.

Average of Job "A" = 76098, Below average Job "A" count = 154 and so on...

I mean, when I draw a Bar Graph and keep Job at x axis then all Job should have a different averages and below average count will be calculated accordingly..

Hope this clarifies my concern..

[sunny_talwar]

Kaushal‌ would you be able to provide in Excel the exact numbers you would want to see in the bar chart. I think not knowing what you need exactly might be causing the problem.

[#5]

@Sunny: Please refer the above chart & table which is prepared based on the dummy data I have shared.

[sunny_talwar]

My numbers are slightly off, but here is what I have for you