Need to display the Top N % rows in the Straight Table based on the Number entered in the Input Box (variable).
Can someone help with an example, if this is the dummy data -
I am sorry, haven't got a chance to look at it as I was busy with few production issues. If I get a chance I will take a look this weekend. Also in the output expected as you mentioned below:
Expected output -
Top 5% - Technically/mathematically will not give me anything.
Top 6% - Account C, Product ghi , Dollars 42000 (1 row in chart)
Top 10% - Account C, Product ghi , Dollars 42000 (1 row in chart)
Top 12% - Account C, Product ghi, jkl, Dollars 42000, 38000 (2 rows in chart)
What is the calculation to show Account C, Product ghi, Dollars 42000 under "Top 6%" ? Can you please elaborate in detail with the formula if you have one.
Ok got it. Then if you say show top 10%, is it not it should show the below records in the chart ?
Account Product Sales %
A DEF 25000 9%
C def 28000 8%
C jkl 38000 6%
C ghi 42000 6%
Also please see the calculation table below: