How can I rank total sales by store code and still show the production codes that comprise each rank.

  
DEFINE FILE SALES
TOT_SALES/I5 = UNIT_SOLD * RETAIL_PRICE
END

TABLE FILE SALES
SUM
TOT_SALES
RANKED BY TOTAL HIGHEST TOT_SALES NOPRINT
BY STORE_CODE
-*BY PROD_CODE
END

If you uncomment prod_code it will change the rankings because it is ranking by 2 by fields. I want to preserve the rankings by store_code, but display the prod_codes sold within each store code.

Thank you for your help. I'm still quite new to WF.

This message has been edited. Last edited by: Joey Sandoval,

I was able to solve with the following multi-verb query.

 
DEFINE FILE SALES
TOT_SALES/I5 = UNIT_SOLD * RETAIL_PRICE;
END

TABLE FILE SALES
SUM
TOT_SALES
RANKED BY TOTAL HIGHEST TOT_SALES NOPRINT
BY STORE_CODE

PRINT  PROD_CODE
BY RANK
BY TOT_SALES

END

 

This message has been edited. Last edited by: Joey Sandoval,

Very good - I wouldn't have figured that out.

quote:

DEFINE FILE SALES
TOT_SALES/I5 = UNIT_SOLD * RETAIL_PRICE;
END

TABLE FILE SALES
SUM
TOT_SALES
RANKED BY TOTAL HIGHEST TOT_SALES NOPRINT
BY STORE_CODE
ON TABLE HOLD
END
?FF HOLD

A little peek helps...