akpaga akpaga
Top achievements
Rank 1
Rank 1
akpaga akpaga
asked on 27 Apr 2012, 10:15 PM
Hi friends
How can I sum up a column values of a table created using the table wizard?
I need to show it at the end of the column .
Thank you
How can I sum up a column values of a table created using the table wizard?
I need to show it at the end of the column .
Thank you
2 Answers, 1 is accepted
0
akpaga akpaga
Top achievements
Rank 1
Rank 1
answered on 30 Apr 2012, 03:47 PM
Can Some admins pleas help me with this?..Thank You
0
akpaga akpaga
Top achievements
Rank 1
Rank 1
answered on 30 Apr 2012, 06:42 PM
Finally figured it out....Posting the solution for some one who may need it in future...
Click on the table (created by wizard )details row: Insert row-Outside Group below: and then the
=Count(IIf(Fields.CustomerType = Daily', 1, null)) (based on condition where Customertype= 'Daily')
if no conditions then =Count(Fields.<your field Type>)
Click on the table (created by wizard )details row: Insert row-Outside Group below: and then the
=Count(IIf(Fields.CustomerType = Daily', 1, null)) (based on condition where Customertype= 'Daily')
if no conditions then =Count(Fields.<your field Type>)