Sum and Count of field in top of row in pivot or straight Table

[#1]

Hi All,

            I have a requirement, where i can see the sum and count of the field in a total row of the pivot or stright table, So please find the attached document and as mentioned in that the text box value should appear in single column.

Please let me know in case you need any more information on it.

Regards,

Ravi.

[its_anandrjs]

Hi,

I think in place of that if you use Statictics Box

See attached sample

Rgds

Anand

[swuehl · Accepted solution]

Hi,

You need to show sum and count in a single same cell?

You could use dimensionality to check if you are in total dimension and then use a concatenation to display your values, like

=if(dimensionality()=0,SUM(Qty)& '  ' & Count(Cdate),sum(Qty))

as expression for sum, giving total sum and count in total row in one single cell.

Hope this helps,

Stefan

[its_anandrjs]

Hi,

You can use this way also paste this code in expression

=Sum( Qty ) & ' ' &Count(Cdate)

See the attached sample file.

Rgds

Anand

[#5]

Hello Stefen,

                     It is Correct and Thanks for giving correct answers.

Regards,

Rk

[its_anandrjs]

Hi,

Stefans answer is absolutely correct but if you use like

=Sum( Qty ) & ' ' &Count(Cdate) you get its value also.

Rgds

Anand