December 2019
Beginner
370 pages
8h 9m
English
We now hold the tools to understand why only one customer shows up:

If we take a look at the order of operations, the top N filter comes before the dimension filter (in this case, for State Wales), but after the data Source filters (here, Country United Kingdom).
The sales shown in the results are therefore sales in Wales for customers that are in the top 10 UK-wide, not just in Wales. Nine of those customers have no sales in Wales, just in the other parts of the UK, and don't appear in our results.
If one wanted to see the top 10 customers in Wales for sales occurring there only, it is possible to promote ...
Read now
Unlock full access