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?
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).
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.