Hello,
My table has Date, Product, Qty columns. I want to create a view, where user can select a date range and see total qty of each product, as well as grand total (of all products). With โgroup byโ in the view, I can get total qty for each product, but still struggling with grand total. I end up creating a virtual column (ALL) and create another view to group by โAllโ first (get Grand Total), then go into the intended view (get Sub Total). But it requires 2 steps, which is quite inconvenient.
Can you suggest any workaround for this problem.
Thanks,
Anh Han
This is not a trivial problem. I imagine a dashboard that includes a view to allow the user to input the desired dates, a view to display the corresponding product totals, and a view to display the grand total. Alternatively, a detail view could be used rather than a dashboard.
Thank you, Steve. Iโll try your suggestion and get back later.
Anh Han
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |