Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
the data in green are the highest prices in that category, in red the lowest prices
thanks for your help!!!
May be try this:
=aggr(if(rank(sum(Prices))<=3 or rank(-sum(Prices))<=3,[Product Category]),City,Area)