I have a list of product codes I want to exclude from my report as this data is not relevant.
I have tried using a mapping load but that didn't work. I have tried linking in an extra table and that hasn't worked either. Even using the product code field as a list box and excluding the codes from there still does not amend the charts and graphs.
Ideally I would like to exclude the data in the script but that is proving harder than I thought.
I have attached the qvw file and a list of the products I am trying to exclude. They all have the same StockSANAL code of BEVA so I have tried to exclude that as can be seen in the qvw file. Excluding this data will make a massive difference to the Ave. TU per pick graph as these products are picked in the tens of thousands which is what causes the spike. So removing them would bring that bar more in line with the weeks around it.
