Transaction grouping for items obsolete stock purposes

[Amanda1234]

Hi,

I need to filter out the codes that have only a stocktake transaction (or no transaction for the year) and not actual transactions to create an obsolete report or Power Bi.

How do i group information then filter.

 

[alansidman]

1. Cannot manipulate data in a picture. Please reload your sample data using XL2BB
2. Please show a mocked up solution of what you want your sample data to look like. In this manner we can be assured of your presentation and not have to guess.