Hi. We are currently working on a BI project and we have difficulty
getting
the right MDX query for the following business requirement

Dimensions:

Time (Year-Semester-Quarter-Month)
Geography (Region-Estate-City)
Sale channel (Distributor)

Measure: Units

Parameters: Year, Month From, Month To

It wanted to know like being able to obtain the amount of distributors
whom there are sold in the period and to compare it with the amount of
distributors whom have sold of himself period but of the previous year.


They are not due to tell to the distributors whom have sold more of
once, for example if a distributor sold 10 units in different days,
single it is counted like a single distributor.

The result should look like this:

Distributor PY Distributor
Norte (Región) 50 60
Nuevo león (Estate) 40 45
Monterrey (City) 40 45
Coahuila 10 15
Saltillo 10 15
Sur 15 10
Chiapas 5 7
Tuxtla 10 7
Oaxaca 10 3
Oaxaca 10 3

Cheers