Show item counts in subtotals

Contents[Hide]

1. Overview

This article shows you how to display a count of the number of items that make up the total amount in rows displaying subtotals.

2. Display item counts in tooltips

If you have rows displaying subtotals in your table, the tooltip for both the subtotal text and the value cells will show a count of the number of items that make up the subtotal amount. This is the standard behavior in Dundas BI 2.6 or later.

Tooltip for subtotal text shows the count of items
Tooltip for subtotal text shows the count of items

The tooltip on the subtotal value also shows the item count
The tooltip on the subtotal value also shows the item count

The item count is always displayed in the tooltip, even if you're using Flat Table mode or if you've customized the subtotal text.

3. Display item counts as text

Go to Properties for your table visualization. Click Text and look under the TABLE section.

Enable the Show Item Counts In Subtotals checkbox option to see the item counts displayed as part of subtotal text.

If your table is using Row Header mode and you have hierarchies with multiple levels, you'll also see these counts displayed as text in expanded row header cells. The corresponding table columns will need to be wider to accomodate this extra bit of text.

Show the item counts in subtotal text
Show the item counts in subtotal text

Note that the item counts will not be displayed if you customize the subtotal text (but the counts will still be shown in tooltips).

4. See also

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri