I want to create a dashboard that at the end of the column contains calculated fields, where I can place the sum of the columns, as shown in this example:
I need to show at the end of the dashboard the summation of the total amount of all quotes, this is my expected result:
How could I do this within the BAQ or dashboard modules?
First, setup the BAQ to return all the data, no groupings or summaries. Then in your dashboard, when you build it in Dashboard Maintenance, use the standard column tools to right click and add a summary, and/or a group by. Choose the type of summary you want (sum, avg etc.) Then look at the bottom of the group (if you’re grouped) to see the total. If you save your dashboard this way, when you deploy it to the menu, it should retain the summary and grouping.
Good luck!
Nate
I got the result successfully, thanks.
