Hello all,
I have sales by product and by month. I want top 10 products based on percent increase from previous period. I'm sure this is straight forward but I'm unable to find out a way to use Top by formula on my product.
Please help!
P
1) Drag Sales, Month Fields onto Column shelf.
2) Right click on "Product" column, click on Create set.
3) Select Top Option, Select "By Field", Define Parameter Name, Minimum, Maximum. Interval.............
4) Drag Product onto Row shelf.
5) Drag Set onto filters shelf, select "IN"
6) Right click on Parameter, click on "Show Control".
================
If you want to use formula, then follow the below screen shot.
Click on Edit , then type the formula which ever you want.
In this screen shot, i used sum([Sales])
