How to transform expression in Dimension

[Anonymous]

Hello

i already have a bar chart with this expression sum(aggr(if(Count([Libellé])=1,1,0),[Référence mouvement 2]))

How can i create a dynamic dimension with this expression :  sum(aggr(if(Count([Libellé])=1,1,0),[Référence mouvement 2]))

This expression is to categorize the number of product [libellé] by order [Référence mouvement 2] . in this case, it count how many order have just one product

i want to have a dynamic dimension like  

= 1 [libellé]

= 2 [libellé]

= x[libellé]

= > x [libellé]

and an expression : count ([Référence mouvement 2]) or sum(value) 

How can i do that ?

thank you for all.

[kaushiknsolanki]

Try this,

aggr(Count(Distinct [Libellé]),[Référence mouvement 2])

Regards,

Kaushik Solanki

[Anonymous]

Thanks you

it seem's working

do you know how can i order this ? i'll try few thiongs but nothings works? 

[kaushiknsolanki]

Hi,

You can promote the Dimension to top and then select the Numeric Value as sort order.

Regards,

Kaushik Solanki

[Anonymous]

Hello again

- i made a dimension like : aggr(Count(Distinct [Libellé]),[Référence mouvement 2]) = 2 (or another number)

- My expression : Count (distinct([Référence mouvement 2]))

i have some négative results?  i don't know how interpret it ? is it "normal"

?

did i made a mistake on my dimension?

[Anonymous]

Yes!!

it works for the order.