Seperate count records and create a percentage

W

Wayne

I am trying to create a Report from 1 table but different columns
counts with percentages.

First column
2nd Column
Item1 (Rcrd cnt of Item1) onhand qty = 0 (Percent) Rcrd cnt
onhand qty > 0 (Percent)


Item2 (Rcrd cnt of Item2) onhand qty = 0 (Percent) Rcrd cnt
onhand qty > 0 (Percent)


I have a few columns to create with these types of scenerios. Any help
would be appreciated.
Thanks
Wayne
 
Top