Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to find the Manufacturers whose sales are over 100,000 for the 2 categories CHEESE CAKE and ACC in January 2013 (period P01/13). But I want to remove from that list those whose sales are lower than 50,000 for all categories in January 2012:
write set analysis code for this
I tried with this
Only({<Sales={">100000"},categories={'CHEESE CAKE' ,'ACC' },period={'P01/13'}>-<Sales={"<50000"},categories={*},Period={'P01/12' } >Manufacturers})
Can some one correct this expression.
Thanks in advance
What Only(Manufacturers) returning?
Only({<Sales={">100000"},categories={'CHEESE CAKE' ,'ACC' },period={'P01/13'} - Sales={"<50000"},categories={*},Period={'P01/12' }>}Manufacturers)
Can you share your data in excel format?
Yes Anil, need Manufacturers who satisfies above condition.