I've the following chart, which is working with the following expressions and dimensions:
Expression: count(DISTINCT KEYC)
Dimensions: DASC //Date format NCIC //Company name
And I'm sorting DASC by Numberic Value, and NCIC by the same expression: count(DISTINCT KEYC)
My question is: Why it is not sorting NCIA by the result of expression?
I would like to have Dates (DATC) on cronological order on X axis and the result of expression (count(DISTINCT KEYC)) ordered from the biggest to the smallest result per NCIA on Y.