Hi, I’m making a summary report I know how to do it, but I’ve a little question,
Let me first show the data that must be summarized
[TABLE=“border: 0, cellpadding: 0, cellspacing: 0, width: 180”]
[TR]
[TD=“width: 80”]IdProject[/TD]
[TD=“width: 80”]City[/TD]
[TD=“width: 80”]Value[/TD]
[/TR]
[TR]
[TD=“align: right”]100[/TD]
[TD]Bogota[/TD]
[TD=“class: xl63”] $ 1,000.00[/TD]
[/TR]
[TR]
[TD=“align: right”]100[/TD]
[TD]Lima[/TD]
[TD=“class: xl63”] $ 3,500.00[/TD]
[/TR]
[TR]
[TD=“align: right”]300[/TD]
[TD]Buenos Aires[/TD]
[TD=“class: xl63”] $ 4,000.00[/TD]
[/TR]
[TR]
[TD=“align: right”]400[/TD]
[TD]Lima[/TD]
[TD=“class: xl63”] $ 500.00[/TD]
[/TR]
[TR]
[TD=“align: right”]400[/TD]
[TD]Santiago[/TD]
[TD=“class: xl63”] $ 700.00[/TD]
[/TR]
[TR]
[TD=“align: right”]400[/TD]
[TD]Caracas[/TD]
[TD=“class: xl63”] $ 800.00[/TD]
[/TR]
[/TABLE]
Tb1: Data Detail
[TABLE=“border: 0, cellpadding: 0, cellspacing: 0, width: 352”]
[TR]
[TD]Etiquetas de fila[/TD]
[TD]Cuenta de IdProject[/TD]
[TD]Suma de Value[/TD]
[/TR]
[TR]
[TD]Bogota[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]1000[/TD]
[/TR]
[TR]
[TD]Buenos Aires[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]4000[/TD]
[/TR]
[TR]
[TD]Caracas[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]800[/TD]
[/TR]
[TR]
[TD]Lima[/TD]
[TD=“align: right”]2[/TD]
[TD=“align: right”]4000[/TD]
[/TR]
[TR]
[TD]Santiago[/TD]
[TD=“align: right”]1[/TD]
[TD=“align: right”]700[/TD]
[/TR]
[TR]
[TD]Total general[/TD]
[TD=“align: right”]6[/TD]
[TD=“align: right”]10500[/TD]
[/TR]
[/TABLE]
Tb2: Summarized data
Well I didn’t see into scriptcase "Totals"section an option for count the values inside a column in this case IdProject.
I apreciate your help.
Thanks