Question

[#1]

Hi,

i have a project dataset where the one project is repeated several times in a county . how do i show only one project in a country.

[Anonymous]

If you want the amount to be aggregated, use sum(amount) in the expression.

[ahaahaaha]

Hi,

May be field Amount in table shift in expression, as SUM(Amount)

Regards,

Andrey

[hector_munoz]

Hi Saran,

You have a total amount of records as all the possible combinations of fields used in the table. If you want a record per country and project combination you should remove those fields that break this rule: year, amount (this could be an expression), ...

Regards,
H

[kkkumar82]

Hey as per my understanding your data has a uniqueness over other columns , if you use only first two columns as per your pdf and an expression then that rows will not be repeated

[beck_bakytbek]

Hi Saran,

try this:

Sum({<Country= {"Afganistan"}>}Amount)

or in Scriptarea:

(if your folders like projTitle, ManagingDivision,ProjStatus,ActualStartDate have the same information like in your attached example)

Load

Country,

Sum(Amount) as Amount

group by Country;

i hope that helps

Beck