Suppose: I have only 1 customer, that’s all. This customer is new in january.
The counting in the cube is like:
Year Quarter month #new #customers
2015 1 1 1 1
2015 1 2 0 1
2015 1 3 0 1
Subtotal quarter 1 1 3
As said, I have only 1 customer. The total new customers is correct, but the total customers is NOT. This is only possible if I count the unique values.
On the internet I found “countdistinct".
More information I found on:
https://www.devexpress.com/Support/Center/Question/Details/S170268
Implemented:
- v2014 vol 1.3 : Download official update
Additional information:
With v14.1, a new summary calculation mode has been added – Count Distinct.
Is it possbile that this will be implemented in de SF. It would be very helpfull.
