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,