Dynamic Grand Total in View

[pmhungdao]

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

[Steve]

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.

[pmhungdao]

Thank you, Steve. I’ll try your suggestion and get back later.
Anh Han