display items wich sales 1 for month

[#1]

Hi.

I want to display items which sales 1 for month. I showed in the figure these items

Thanks

[Gysbert_Wassenaar · Accepted solution]

Try these expressions:

Number of items: Count(distinct if( aggr(count(Date),Item,Month)=1, Item))

List of items: Concat(distinct if( aggr(count(Date),Item,Month)=1, Item),', ',Item)