QV - Chart Top 10 evolution (positive & negative)

[stephane_kosior]

Hi,

I would like to create a chart showing the top 10 evolution (positive & negative) by customers.

Here it is the Top 10 positive but how to include the negative value in the same chart ?

Many thanks

[Anil_Babu_Samineni]

Possible, Let me know how can we help you?

[stephane_kosior]

Many thanks for your answer but is there any chance you can provide some explanations ?

[Anil_Babu_Samineni]

Here are the approaches, I usually followed in measure

+ve -- SUM({<Name = {"=Rank(SUM(Amount))<=10"}>}Amount)

-ve --  SUM({<Name = {"=Rank(-SUM(Amount))<=10"}>}Amount)

Dimension level, It would be this?

+ve -- If(Aggr(Rank(SUM(Amount)), Name)<=10, Name)

-ve -- If(Aggr(Rank(-SUM(Amount)), Name)<=10, Name)