TOP 3 SALES

[#1]

Hi,

i have sales, city columns

i want top 3 sales of city

HOw to do it?

[rajkumarb]

HI

You Can limit Values In the chart Properties in Charts

[buzzy996]

try this,

1. city as ur dimension

2. sum(sales) as ur expression

3.

[anbu1984]

Search the forum. You will get lot of examples

[jyothish8807]

Try this in dimension:

if(aggr(Rank(sum(Sales)),City)<=3,City)

In Expression:

sum(Sales)

Regards

KC

[#6]

Hi

u can try using dimension limit and also the rank function as well.

Regards

Deepak