Hi gurus,
I have a problem in a query
I have a lot of records that are the same and I dont want to sum the value of them more than once. How can this be done??
The following table should illustrate my problem:
What the OLAP-engine does:
Type--
Contents
40000000000
----3
Contents
40000000004
----5
Contents
40000000009
----5
Contents
40000000010
----1
-
<b> Result 14</b>
Appearance
40000000000
---3
Appearance
40000000004
---5
Appearance
40000000009
---5
Appearance
40000000050
---5
-
<b>Result 18</b>
-
Overall Result <b> <u>32</u></b>
I want the Overall result to be 19. (only summing up unique records).
Any help will be greatly appreciated.
Thanks,
Br
Anders
<b></b><b></b>