Pivot Table Error - Minimum Value

[Maria Clara]

Hello All,


I'm trying to create a pivot table to identify the lowest price paid in a product. It works fine until I add the supplier name on the table, then it shows me all the prices and not the lowest one.


Please find below the example:


http://www.sendspace.com/file/13d6rg


Can anyone please help me with that?


Thank you!

 

[Faseeh]

Hi Maria clara,


why donot u add the suppliers to the column area? U will have min price of each againt all products?


Faseeh

 

[inbp]

Hi Maria Clara,


Please find below the attached file.


if you are using Excel 2010 you can use Slicers as filter


https://www.dropbox.com/s/l5bp34iookms4pc/Pivot%20Example-Maria%20Calara.xlsx


Regards,

Muhammad Shakeel