1 Reply Latest reply: Sep 13, 2018 7:51 AM by Bala Bhaskar RSS

    3 highest prices and the three lowest prices in pivot table

    Hermilo Israel Gayosso Murillo

      Hello, I am looking to create a pivot table in which you can visualize the 3 highest prices and the three lowest prices by product category, by city and by area.

       

       

      The table should look like this:

      Sin título.png

      the data in green are the highest prices in that category, in red the lowest prices

       

       

      thanks for your help!!!