To take only one value

[polisetti]

Hi,

I had a straight table in which 1 value is repeating for 2 regions ,but in which i want to show only value.Please see attached screen shot.

[maxgro]

try with

sum(distinct  yourfield)

[hic]

You most likely have a problem in your data model; a problem that creates these duplicates. So, fix your data model.

Sum(distinct ...) may work, but is a bad solution. It removes the symptom but not the problem.

HIC

[polisetti]

I alreay tried it but the value in total is not matching .i need to show total as 5000 but it is getting less value.

[MK_QSL]

Looks like there are duplicated rows in your data model.

Try to use

Load Distinct

While Loading the data.