Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try with
sum(distinct yourfield)
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
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.
Looks like there are duplicated rows in your data model.
Try to use
Load Distinct
While Loading the data.