0 Replies Latest reply: Apr 3, 2013 5:32 PM by majd saad RSS

    Sales by Outlet Vs Stock by Warehouse

      Dear all,I have the following data:

       

      estimate:

      warehouses are : X,Y,Z
      Outlets are:         L,M,N

       

      In my filters i have year, month, day , category ,subdivision, OUTLET ,WAREHOUSE.....

      I am working to execute the following table:

       

       

      Table :

                                                          X                                                                                                                  Y

      product ID     Stock quantity   Stock Value      Sales Quantity        Sales Amount            Stock quantity   Stock Value      Sales Quantity        Sales Amount

       

      100                                     

      200                      

      300                      

       

       

       

       

       

       

      Is it possible to use a function to select an outlet in the filter "example L" , and get  sales quantity and sales value by outlet vs stock quantity and stock value by warehouse.

      Regards,