by Roxie2401 » Thu Apr 21, 2022 6:53 am
That's interesting.
I would have thought by just selecting "Album" in the File>Reports>File List it would have just giving one instance but I can understand that it is "Selecting Column" and since the column contains all the album names for as many titles, you can't get just one entry per album ----- its currently giving just what is in the "selected column."
Maybe the developers can group like you showed in order to generate an Album report.
I did export to excel and then clean it up by listing unique ( in column A1 set the formula =B1=B2, where column A is empty and column B contains the "Album report" from MM and copy that to the end of the list and get a True/False list, then delete all the True entries, leaving just the single, now unique Album names). But for a very long library list, sort of a sledge hammer approach.
That's interesting.
I would have thought by just selecting "Album" in the File>Reports>File List it would have just giving one instance but I can understand that it is "Selecting Column" and since the column contains all the album names for as many titles, you can't get just one entry per album ----- its currently giving just what is in the "selected column."
Maybe the developers can group like you showed in order to generate an Album report.
I did export to excel and then clean it up by listing unique ( in column A1 set the formula =B1=B2, where column A is empty and column B contains the "Album report" from MM and copy that to the end of the list and get a True/False list, then delete all the True entries, leaving just the single, now unique Album names). But for a very long library list, sort of a sledge hammer approach.