Hi, Please help me to list say top and bottom 8 products based on sales for particular year? i should able to get by just entering X=? some no. to get the result.... please see the attachment for model template given to me
Solved! Go to Solution.
All you have to do is Create a chart with Customer name. Add expression as Sum(Sales).
Go to Sort. Keep Sum(Sales) with ascending in case you want bottom customer and Descending in cae you want Top Customer.
You can limit the number from Properties-> Presentation -> Max Number(1 -100) ->Set this to 8.
Hope this will help you
Good morning! friend
I am facing the same problem and I need your help
I try to display the first 10 sales per country in a Pivot table
so I added this expression in dimensions
and as a result I have
as you can see for 2010 it gives a result USA-> France-> germany and the logical order is USA-> France-> UK
Thank you for your answers
This is great but what is I want product to be selected on insertion of vTop variable.
Currently chart is changing on variable but there is no selection of subproducts.
I want product to be selected as well