I am Currently Working on the requirement where i have to select the top 10 or top 100 Products which had the maxium sales for the day,week and month I am not quite sure as to how i can go about.
Can Any one please help me with this please.
Many Thanks in Advance!
All you need to do this, create a request that brings the top 10 or 100 products based on sales or whatever measure. You may use the TOPN function or any approach that bring the top products for the week, month etc.