Pivot table Show products sold only in one year

[Exceladd1ct]

Hello,

I can't post a screenshot with my pivot right now, but please consider a simple tabular pivot table with 2 columns.

Column 1 contains years 2000-2020( group by date feature) and Column 2 has some product names sold in that year from column1. No agregation, only this 2 columns. (I'll post a screenshot as soon as I can)

How do I get the pivot to show me the product names that appears to be sold only in eg. 2015 and no other year?

Thank you.

 

[Exceladd1ct]

I managed to attach a screenshoot of the pivot table.

How do i filter the pivot table to show only the Products that apear in 2001 and do not apear in other years?

In my case it should only show the product "ssssss".

Thank you.

 

[alansidman]

Move the years to the Filter "Box" and then select only the years you wish to see.

 

[Exceladd1ct]

Move the years to the Filter "Box" and then select only the years you wish to see.

Hello, yes this is convenient in this situation, but if I add more data to year 2001, data which already exists in other years, it should only show the products that has been sold in 2001 only.

 

[alansidman]

If you add new data, then click on the refresh button, it should only show 2001.