Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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..
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.
@Sunny: Please refer the above chart & table which is prepared based on the dummy data I have shared.
My numbers are slightly off, but here is what I have for you