5 Replies Latest reply: Jan 10, 2018 1:08 AM by Yeo Poh sai RSS

    How to modify my table to display inventory turn over ratio vs On hand stock amount ?

    Yeo Poh sai

      Hi All


      I have a table 1 , which is working fine,


      This table able to show me the :-


      inventory turn over ratio = base on average month sold amount / with on hand stock amount.


      Now i like to view the inventory Turn over ratio vs on hand stock Amount. Look some thing like below :-


      Inventory Turn over ratio........ On hand amount

      >01-10........................... 100,000

      >10-20............................200,000

      >20-30............................400,000

      >30-40............................500,000

      >40...............................600,000


      Hope some one can advise me.


      Paul Yeo