Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I don't really understand your question, would you be able to elaborate or share some sample data?
in dimension limit to give the largest value is 10
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 |
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
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.
In this case you would be getting only 2 Product sales as you are having a & b product
you can use rank function to get top values
-Sathish
if i use rank function for both top 10 means.....it will give 11 ?
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