Show the stores where the selected product is not sold

[#1]

Hi,

I have many stores across multiple retailers - when selecting a product I would like to show only the stores where that product is not sold

I have tried the following expression 'count({1-$} [Store Name])' - this works but shows all stores across all retailers where the product has not been sold. I need it to show the stores for the current selected Retailer only

Thanks

[chematos]

My recomendation is that you write 1 in the load script for each row with no sales and you could use sum(NoSales) that increase the performance than using Count

Load *,

if(isnull([Store Name]),1,0) as NoSales

From XXX;