1 Solution
Accepted Solutions
Check the screenshot out:
1) You need to change the formatting to 'Custom'.
2) Your Word1, Value1 has two Min(Value1), I don't know which one you wanted to see, but using DISTINCT would show you one of them.
HTH
Best,
Sunny
Check the screenshot out:
1) You need to change the formatting to 'Custom'.
2) Your Word1, Value1 has two Min(Value1), I don't know which one you wanted to see, but using DISTINCT would show you one of them.
HTH
Best,
Sunny
Yes i know that i had 2 values for that, i was just testing the functionality of it. so i took word2 and value2 without duplicates and had the same problem. That is why i was wondering what the problem could be. So the formatting was the problem!
Thank you 
Regards
Chris
