[Wactclc-alma] Overlap P and P

[Guidry, Wade]

For this, you can create a pivot table (same concept as a pivot table in Excel, or a crosstab query in Access).

Create your analysis in the physical items subject area.

Add bib title, and material type where any equals DVD or VHS.

Then, create a pivot table the title as rows, and the material type as column.

That will give you a row for each title, and whether the title as DVD, VHS, or both.

For pivot table instructions, see:

https://knowledge.exlibrisgroup.com/Alma/Knowledge_Articles/How_do_I_create_a_Pivot_Table_in_Alma_Analytics%3F

You could also do the same thing by exporting the basic analysis to Excel, then doing the pivot table in Excel. You would achieve the same thing.


Wade Guidry
WACTCLC
Library Consortium Services Manager
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
http://www.wactclc.org<http://www.wactclc.org/>
509.760.4474

Pronouns: he/him/his


From: Wactclc-alma [mailto:wactclc-alma-bounces at lists.ctc.edu] On Behalf Of McGaughey, Colleen
Sent: Wednesday, August 26, 2020 3:09 PM
To: 'WACTCLC Alma Discussion' <wactclc-alma at lists.ctc.edu>
Subject: [Wactclc-alma] Overlap P and P

I have been trying to run an overlap analytic report to see what titles we have on VHS that we also might have on DVD. The Alma Overlap report uses Titles, and unfortunately the only material type available in this overlap report is Bibliographic material type. This means when I go to filter the list, I am unable to select video cassette and DVD. I am only able to select Visual Material. Does anyone know how to work around this?

At some point, I would actually like to include Electronic inventory, but for now, I just wanted to get an idea of what we might have on VHS can that safely be withdrawn from our collection.

Thanks!
Colleen


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200827/33f64ae4/attachment-0002.html>