Hello, by using Count(quantity) it will always break down to your deepest layer of dimensions. you can set the TOTAL Qualifier Change that: Count(TOTAL <Client_Number> quantity) Count(TOTAL <Client_Contract_Number> quantity)
that Expression should do the trick for you. regards tim
first of all, you want to count the quantity or sum it?
Also, you are looking for this to be done in the script? in a single load aggregating over different dimensions? I don't think this is possible. Can you elaborate on the context of this thing. May be there is another way to do this?