to clarify the question above. My current selections are as per the image below:
The purpose of the Sales dashboard is to show closed orders (i.e. Order Status = C) for the current period and market segments selected or any other selections made, e.g. region, country, etc). I now want to add another object on the dashboard to summarize the values of Open Orders (i.e. Order Status <> 'C') showing totals for different held reason codes within the selected markets, regions, countries etc while still viewing the closed orders in the main table below.