Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
I think in place of that if you use Statictics Box
See attached sample
Rgds
Anand
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
Hi,
You can use this way also paste this code in expression
=Sum( Qty ) & ' ' &Count(Cdate)
See the attached sample file.
Rgds
Anand
Hello Stefen,
It is Correct and Thanks for giving correct answers.
Regards,
Rk
Hi,
Stefans answer is absolutely correct but if you use like
=Sum( Qty ) & ' ' &Count(Cdate) you get its value also.
Rgds
Anand