im using the data analysis
"
---------------------------------------------------------------------------------------
1-(count({< Date={"$(=max(Date))"}, Stock={"<=5"}>} distinct TopSku)
/
Count({<Date={"$(=max(Date))"}>} DISTINCT TopSku)) "
---------------------------------------------------------------------------------------
to get the avaliblity for the topsku with 5 or less items in the store/div/supp/group..... ,
and this is my two tables im using here
---------------------------------------------------------------------------------------
stock :
Daily_Stock:
LOAD
DT,
PRODUCT ,
DESCRIPTION,
PRODUCT as sku,
Price,
WAC,
"DIV",
Division,
GRP,
"Group",
CTG,
SubGroup,
BRAND,
STORE_ID as TRXH_LOC_CODE,
Stock,
if(Stock<=5 and Stock>0,'1','0') as AVb_Stock,
---------------------------------------------------------------------------------------
and for the topsku :
TopSKU:
LOAD
ITEM_CODE as PRODUCT,
TopSku,
if(TopSku<=5 and TopSku>0,'1','0') as Avb_TopSku
--> item code is the topsku ,
---------------------------------------------------------------------------------------
put when i use the set analysis im not getting anything expects for the chart called store but the rest nothing anyhelp with this ?>
