One Dashboard, Multiple BAQ Tables

Epicor ERP 10
,
1

Hi

Im new to the group & to Epicor. Im looking forward to getting to understand Epicor more as my knowledge grows. I have a large database background so im not new to data.

Question:
In a single dashboard, i would like to show either of these 2 options:

Option 1
Add a row to bottom of the table that sums all of the values in a column.

Option 2
Add a second table that sums the values of the first table.

In SQL i can add a row like this to the bottom of a SELECT statement

SELECT TOP (100) [field1, field2, field3, field4, field)
FROM dbo.MY_Table
WHERE field1 = 12345

UNION ALL

SELECT 0, 'TOTAL, SUM(field2), NULL, NULL, NULL
FROM dbo.MY_Table

Can i also do this in a BAQ as that would solve the requirement and allow me to have only one table

Thanks

2

Option #1 : Activate Grid Summaries

In the dashboard, any user can interact with the grid to display summaries.

  1. Right click anywhere in the grid and click on “Show Summaries”
    image

  2. Now, summaries icons appears on the header of columns. Click on it, check “Sum” and click “OK”
    image

  3. The summary appears at the bottom of the grid
    image

Option #2 : Summary row in BAQ

In your BAQ, you can use an union subquery to get the same result as your SQL statement

image

This is explained in the Ice Tools User Guide

5 Likes
3

Sorry, i didnt have notifications on… Thanks for the reply. Both options look good, i prefer the Union option but question: if i set a summary in the dashboard, will it persist or is it something we would need to turn on each time?

Thanks

4

You need to click Tools → Save Layouts

5

thanks :slight_smile:

1 Like