Pivot Table extraction Non-Repeated Records (3)-minimum values in each group

Pivot Table extraction Non-Repeated Records (3)-minimum values in each group

Key design points: non-repetition and pivot tables

Xiuxiu: Getting Started again!

Ajin: Let me tell you, this is the most amazing! Create a pivot table and place all fields in the row area in sequence, such as "item name", "category", "quantity", and "amount, the "quantity" to be searched must be placed next to the "Group", such as "item name" and "category". This sorting method works.

Xiuxiu: Oh, right-click the "quantity" field and choose "sort"> "ASCENDING" to find the minimum value?

Ajin: Yes, and then click "design"-"Category summary"-"Do not show Category summary" in the same menu. Change "report layout" to "display in Tables ".

Xiuxiu: Well, all the records are there? You only need to find the minimum value record for each group

Ajin: Copy the pivot table to a plain text area. You only need to filter the "category" column and remove "(blank )".

Xiuxiu: Oh ......

Ajin: A bit hard to understand, right?

Pivot Table extraction Non-Repeated Records (3)-minimum values in each group