I am trying to create a pivot table with PPID. For example, I want to show for each PPID, how many specimen of each specimen type I have. So, my rows will be PPID and column will be specific specimen types such as buffy coat, plasma, frozen tissue.
When I tried to do such pivot table, I got the following error message “Non-admin users cannot run pivot table queries containing PHI fields. (QUERY_PHI_NOT_ALLOWED_IN_AGR)”.
My colleague was able to reproduce this and she said that it appears only super-admin can do pivot table with PPID.
Wondering is this the case? If so, is there any work-around?