Ask Your Question

Filter data in Pivot Table [closed]

asked 2016-03-17 01:34:40 +0100

matm gravatar image

I have the following data:

Product Client  Quantity
Flower  John    1        
Flower  Paul    2
Shirt   Steve   1
Shirt   Lily    3
Pencil  Mark    1
Pencil  Jack    2
Pencil  Emma    3

Goal: I would like to extract, for each product, the line where the quantity is the biggest.

I tried with a Pivot Table, and didn't find any acceptable configuration. I don't know if I did well, though. Standard filter did not work neither, not saying the real data is not sorted

Once sorted, I can add a column with a formula like =IF(A2=A3;"";1) to mark the Product Switch, then assulming this is my max line.

Is there any real solution to reach my goal without preprocessing like sorting data ?

Thank you

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-01 17:40:45.377519

1 Answer

Sort by » oldest newest most voted

answered 2016-03-17 01:43:46 +0100

karolus gravatar image


Drag&drop Product to Rowfields, drag&drop Quantity to DataField doubleclick it and change from sum to max … thats all!

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-03-17 01:34:40 +0100

Seen: 542 times

Last updated: Mar 17 '16