Hello!
I am trying to design a PowerCube with a particular measure. This measure is a counter that simulates a Distinct count of some column. For example, i have this information:
Date Card Total
---- ---- -----
1 Jan Trj1 3
2 Jan Trj1 4
2 Jan Trj2 5
3 Jan Trj1 6
In my database, I have 4 records: 3 for Trj1 and 1 for Trj2. When I create the powercube, i have only one regular counter. I need one that makes a DISTINCT for Card.
With the regular counter, the number of cards is 4.
With the DISTINCT counter, the number of cards would be 2.
Please, give an advise to solve this problem.
I am trying to design a PowerCube with a particular measure. This measure is a counter that simulates a Distinct count of some column. For example, i have this information:
Date Card Total
---- ---- -----
1 Jan Trj1 3
2 Jan Trj1 4
2 Jan Trj2 5
3 Jan Trj1 6
In my database, I have 4 records: 3 for Trj1 and 1 for Trj2. When I create the powercube, i have only one regular counter. I need one that makes a DISTINCT for Card.
With the regular counter, the number of cards is 4.
With the DISTINCT counter, the number of cards would be 2.
Please, give an advise to solve this problem.