List box value sum up.

[#1]

I have 2 list boxes.one with amount and another with region values.In amount list box I have amount day by day.How can I sum up that amount as one big amount for 1 region?

Can anybody help me please?

Thanks for all your help.

[CELAMBARASAN]

May be something like

Aggr(Sum(Amount), Region)

or Go to the expression tab of the Region list box and write expression as Sum({<Region=>} Amount)

[tresesco]

Select a region form list box. Create a text box and put expression there like: =Sum(YourAmountField)

Or,

If you want for a specific region, right expression in textbox like:

=Sum(If(RegionField='Region1',AmountField))

Or,

Take a staright table, RegionField as a dimension, and expression as :=Sum(Amount)

[jduenyas]

I do not think you can sum numbers in a List Box. As its name says it is only a list.

For summing up numbers you need a chart object such as a Straight Table or a Pivot Table.

You can display totals as a single value in a text box that has an expression in the text area.

In a Straight or Pivot table put your Region as a dimension and  =Sum(AmountField) in the expression.

[jduenyas]

I would like to correct my previous statement.

You can display the summed up amount in the Title area.

You can enter as a title a formula like this: = Num(Sum(AmountField),'$#,###.##) and the total will be displayed in the title. If you are clever and manipulate the expression more you can even add/append  the text of the selected Region  to the Title  with the total. (Something like this: = 'Region - ' & RegionField & ' = ' & Num(Sum(AmountField),'$#,###.##)