1 of 1 people found this helpful
You might try creating a concatenated field that combines EpisodeID and Status. Add that to your rows shelf before EpisodeID and then Hide the header so the column does not appear. Next create a calculated field like:
If (right([Episode + Status],1)="A" AND [Phase]="1") then 1 else 0 end
Add this calculated field to your Text shelf and each Episode with a Status of "A" and a Phase of "1" will have a 1, everything else will be 0.
Hope this helps,
4 of 4 people found this helpful
1- If Status ="A" then [EpisodeID] else NULL end - as Approval
2-COUNTD([Approval])- as Distinct Approvals
using the distinct as the true count.
Thank you! This just save me so much time!