[Evergreen-reports] Holdings Report

[Elizabeth Davis]

Hello

I'm looking to run a report to for a list of TCNs for a library system where 2 of the 3 libraries own copies, but the 3rd location doesn't own a copy.  I'm looking for TCNs where libraries A and B are the only libraries that own copies.  I have list of TCNs and copy counts, but I'm having a hard time filtering out instances where all three libraries own copies or where library C and A or library C and B own copies.

Has anyone done this type of report or any ideas on how I can filter in either Excel/Sheets or using OpenRefine?

Thanks!

[cid:image002.png at 01D9E257.4074AA40]Elizabeth Davis (she/her), Support & Project Management Specialist
Pennsylvania Integrated Library System (PaILS) | SPARK
(717) 256-1627 | elizabeth.davis at sparkpa.org<mailto:katherine.dannehl at sparkpa.org>
support.sparkpa.org<https://support.sparkpa.org/> | support at sparkpa.org<mailto:support at sparkpa.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230908/b67dca3f/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10034 bytes
Desc: image001.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230908/b67dca3f/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 5399 bytes
Desc: image002.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-reports/attachments/20230908/b67dca3f/attachment-0003.png>