Hi Guys,
Need ur help
| Cash App Executive | Allocation_Status | | 11/17/2014 |
| Anita Gupta | Closed | | 80 |
| Anita Gupta | Reject | | 22 |
| Anita Gupta | WIP | | 16 |
| Anita Gupta | Total | | 89 |
| Deepti.gokhale | Closed | | 37 |
| Deepti.gokhale | Reject | | 23 |
| Deepti.gokhale | Total | | 37 |
| snehal.patil | Closed | | 72 |
| snehal.patil | Reject | | 23 |
| snehal.patil | WIP | | 9 |
| snehal.patil | Total | | 79 |
| Total | | | 205 |
i'm having pivot table where i'm having expression as count(distinct allocation id) which you can see in date column when i'm applying partial sum total for eas cash app executive it is showing wrong.for more clarification .PFA attached qvw
