RE:Same Top 10

[Chanty4u]

hi all,

I have small doubt.

For example i hve  top 10 sales 100  for product "A"

and same for top 10   sales 100  for product"B"

i want to get top 10 sales ?

what will be the result?

[sunny_talwar]

I don't really understand your question, would you be able to elaborate or share some sample data?

[Anonymous]

in dimension limit to give the largest value is 10

[Chanty4u]

hi,

  for below i want to get top10sales

product	sales
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10
a	10
b	10

[kaushiknsolanki]

Hi,

When we load this data, because we have only 2 products we will get only top 2 products.

To get top 10 Products.

Just create a straight table with dimension as Product and use dimension limit tab to define top, and give expression as sum(Sales).

Regards,

Kaushik Solanki

[sunny_talwar]

Hahahaha they all are the same, so my guess is that they should all be part of top 10 unless you don't want them to be.

[Anonymous]

In this case you would be getting only 2 Product sales as you are having a & b product

[sathishkumar_go]

you can use rank function to get top values

-Sathish

[Chanty4u]

if i use rank function  for both top 10 means.....it will give 11 ?

[sathishkumar_go]

not understanding ur requirement properly.

1) You have 2 products each product you want top 10 sales? or u want to see the top 10 products based on the sales?

which is ur requirement?

please post sample data with ur requirement.

-Sathish