Sorting on Pivot table

[#1]

Hi all ,

We are trying to sort on Pivot Table for the resultant value with this Expresion:

(

Count(DISTINCT{<Users={'VIP'}>}  Category)

/[Users Total]

)

But the chart show  "N/A" 

Please can you help us, thanks in advance.

Javi.

[dirk_konings]

Do you get the same result if you add this as an expression to your Pivot Table?

Maybe you have multiple values for [Users Total] on dimension level? Could you use min() or max() on UsersTotal?

Dirk

[#3]

Hi Dirk, the expression is in a Pivot Table, and we have some values on dimension. But we try to sort with only one dimension and the result is the same.

Attach you captures

thanks

PD: Sorry, the QV Software is in spanish

[dirk_konings · Accepted solution]

it says : Garbage after Num#. Is there something else in this expression?

Do the other 3 expression give a result if you deactivate this one?

Please attach a printscreen of your dimensions.

Dirk

[#5]

Thanks Dirk, we are using Num# to convert a value. Now is removed in the expression and the sorting is right.

Regards!!