Display number of rows returned in a pivottable

[alan_grn]

I am planning on having a text object which displays the total numebr of rows in a pivot tbale. How is this best done?

[Anonymous]

You could consider to use a statistics box for totals etc ...

Here you can select the field you want to sum / count / avg .. .etc .

Ofcourse you can also use a textbox with an expression ...

e.g.

='Amount: ' &
Money
(
(
count ( {$< [Calls.SO]= {ERROR} >}Serviceordernr)
-
count ( {$< [Calls.SO]= {ERROR} , Article.Category = {TERMINAL} >}Serviceordernr)
)
 * vAmountVisit
 ,'€ #.##0,00;€ -#.##0,00')
 & chr(10)

Hope this helps you on your way

Anita

[alan_grn]

Thanks. That works