on 10-18-2019 10:40 PM
Hello Experts ...
I'm building report with 3 Objects A, B and C. For every A entry, there can be multiple entries of B or multiple entries of C. The report should show the total number of unique As. I have created a measure on universe with count (Distinct A). But when I add this measure with B | C | Count(Distinct A), and use the sum, I get number which is greater than the number of A I actual have because Webi count the total of entries including multiple entries of B and C for one single A. Does anyone know how to have a report which includes the B, C, and count (Distinct A) and get the correct total of unique As
Thanks for your help.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.