Hi Everyone,
I have a table where it shows logs of different users working on a claim. I want to be able to create a pivot table but the count on the "Status" field should satisfy two conditions.
For this scenario, I want to count the "Pending" status for User1. For User1 to have a count, User1 has to have both "Pending" and "Ready" status. So for claim# 123, User1 will have 1 count but not for claim# 456 because User2 had the Ready status. I hope I have explained it clearly. Thank you in advance.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Claim#[/TD]
[TD]Status[/TD]
[TD]Username[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]Pending[/TD]
[TD]User1[/TD]
[TD]4/1/18[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]Ready[/TD]
[TD]User1[/TD]
[TD]4/2/18[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]Archived[/TD]
[TD]User2[/TD]
[TD]4/4/18[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]Pending[/TD]
[TD]User1[/TD]
[TD]4/10/18[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]Ready[/TD]
[TD]User2[/TD]
[TD]4/11/18[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]Archived[/TD]
[TD]User2[/TD]
[TD]4/13/18[/TD]
[/TR]
</tbody>[/TABLE]
I have a table where it shows logs of different users working on a claim. I want to be able to create a pivot table but the count on the "Status" field should satisfy two conditions.
For this scenario, I want to count the "Pending" status for User1. For User1 to have a count, User1 has to have both "Pending" and "Ready" status. So for claim# 123, User1 will have 1 count but not for claim# 456 because User2 had the Ready status. I hope I have explained it clearly. Thank you in advance.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Claim#[/TD]
[TD]Status[/TD]
[TD]Username[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]Pending[/TD]
[TD]User1[/TD]
[TD]4/1/18[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]Ready[/TD]
[TD]User1[/TD]
[TD]4/2/18[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]Archived[/TD]
[TD]User2[/TD]
[TD]4/4/18[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]Pending[/TD]
[TD]User1[/TD]
[TD]4/10/18[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]Ready[/TD]
[TD]User2[/TD]
[TD]4/11/18[/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]Archived[/TD]
[TD]User2[/TD]
[TD]4/13/18[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: