how to show the particular value in barchart

[#1]

Hi,

I am using barchart and i need to show the particular product bar that have rank 1

i found the rank of product using

rank(sum(sales))

this expression show the rank of product,if rank of product is one it only to be displayed in the barchart with the sales,,

pls..help me out how to done it...

[#2]

Hi,

You can use calculated dimension for product likewise mentioned below:-

IF(AGGR(RANK(SUM(Sales)), Product)=1, Product)

Please let me know for any futher query in this regard.

[Miguel_Angel_Baeyens]

Hello,

You mean set your expression to ?

if(rank(sum(sales)) = 1, rank(sum(vales)))

Hope that helps

[#4]

Hi,

Go to Chart properties-Expression

Beside the Expression (Sum(Sales) in the Expression List, you will see + sign.

Click on it. You will get about 7 options in which Last option is "Show Value".

Click on it. On right hand side, Go to Definition and type expression

Rank(Sum(sales))=1.

Unclick Value on Data points if you have clicked it.

Use Bar chart.

You will get it.

Happy Thoughts