Display only mimum row label in a pivot table

[shepherdc2814]

Hi all,

In the attached spreadsheet, Note the two Row Labels in the pivot table. For the second row label, "Document ID", I would like for only the minimum Document ID to display in each group. For example, under "Site 1" there would only be one line, for "268501".

Does anyone know of anyone I could accomplish this?

Thank you!

[:) Sixthsense :)]

Place the cursor on A7 cell of Pivot Sheet and do right click and select Filter>>Top 10>>Change the 10 to 1>>Give Ok..