Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
ID | UserName | Planed | Actual | Dr |
1 | Khalid | 2 | 1 | A |
2 | Khalid | 3 | 3 | B |
3 | Khalid | 4 | 3 | C |
4 | Khalid | 4 | 4 | D |
5 | Khalid | 4 | 0 | E |
4 | Khalid | 4 | 3 | D |
I have pivot table
UserName Sum(Planed) Sum(Actual) in thir column I want the number of count of Dr whose Sum(Planed) <=Sum(Actual)
how can I achieve this.. sample files are attached
thanks in advance.
Hello,
Try this expression for fully visited.
=Count(If(Aggr(Sum(Planed),Dr)<=Aggr(Sum(Actual),Dr),Dr))
Hope it helps you.
Cheers!!
Jagan Nalla
Hi,
I didn't understood what you said exactly. Could you please explain clearly or else provide some sample output according to your requirement?
Thanks for reply...
sample out put of pivot table
User No_Of_FullyAttended_Doctors
Khalid 1
for only one Dr B the condition sum(planed) <= sum(actual) is true.
Dr | sum(planed) | sum(actual) | Sum(Planed) - Sum(Actual) |
A | 2 | 1 | 1 |
B | 3 | 3 | 0 |
C | 4 | 3 | 1 |
D | 8 | 7 | 1 |
E | 4 | 0 | 4 |
or in other words i need count of Dr where Sum(Planed) - Sum(Actual) <=0
Hello,
Try this expression for fully visited.
=Count(If(Aggr(Sum(Planed),Dr)<=Aggr(Sum(Actual),Dr),Dr))
Hope it helps you.
Cheers!!
Jagan Nalla
Thanks a lot it worked:)