Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts:
I have 3 simple requirements
1- Enter a Treshhold Value (%) : Beside this text object there should be an input box or text box (i am not sure which is the best option..hence, have not added any object)..... if i enter 10 in the textbox/input box, the sales figures should be divided by 10 in the adjacent table
2- The sum of top 10 values from the table should be shown in the text object beside 'top 10 sales'
thanks a ton in advance
Dear YOusuf,
Kindly find the attachment.
I hope it will help you.
Thanks,
Mukram
Hi Mohammad,
Thanks for your prompt reply.
The first ask is done. However, i believe you misunderstood the 2nd ask.
I just want the sum of sales for the top 10 sales to be displayed in text object.
Here it is
See the attachment
Thanks.
one final query. Suppose we dont have any variable. and we just need to display sum of top 10 values from the table and our table has 15 sales person. Then what would be the expression?
In Other words, i just have a table and just a text object in which i have to display the sum of top 10 sales.
Use below expression...
=SUM(Aggr(IF(Aggr(Rank(SUM(Sales)),[Sales Person Name])<=10,SUM(Sales)),[Sales Person Name]))
Instead of 10, you can create an input variable with vTOP and use $(vTOP).
=SUM(Aggr(IF(Aggr(Rank(SUM(Sales)),[Sales Person Name])<=$(vTOP),SUM(Sales)),[Sales Person Name]))
I haven't taken threshold value.. Please add yourself as your requirements.
Hope this help.
1. yes use Input box.
2. use Rank function aggr(if(Rank(sum(Value)<=10),sum(Values),yourdimension)
anant
Thanks Manish..
Hi Sir,
How can I achieve this scenario. Please help