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.
You can change the Summary type in Cube field to Maximum. In some cases (not all) that will do the trick.