Finding "Total" rows without using inter chart function

[#1]

Hi guys,

I am using this expression to avoid "Total rows" from rendering any Date.

If(RowNo() <>0  and not IsNull(RowNow())), TxnDate)..

I want to know if there is any way to find total rows without using RowNo() or dimensionality() in a pivot and straight chart.

-Saurabh

[sujeetsingh]

=count(TOTAL FieldName)

[#3]

should i use

= count(TOTAL TxnDate)

and what is expected output of this function when it finds a TOTAL row...