I HV three table one is customer, sale and saledetails.
In sale and saledetails table customer ID reference from customer [Customer ID]
Now I wants a virtual column type list show the customer used how many items and how much quantity each.(A unique item list With quantity)
Others may offer you different solutions but the easiest to do this, although it is not exactly the structure you described, is
Add a customer id VC to order details by derefence
Create a order details table view grouped by items and set SUM aggregate on sum::quantity
Create a dashboard to include both customers and order details views. Turn on interactive mode.
An Email/Attachment Bot solution is relatively easy.
I can think of a way to do this online by creating a child table to customers with id, cust_id, item, sum columns and updating them as orders are created via actions. It certainly cannot be done by VCs alone.
