Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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 -
Account | Product | Sales |
A | ABC | 10000 |
A | DEF | 25000 |
A | GHI | 15000 |
A | JKL | 18000 |
B | ab | 12000 |
B | cd | 8000 |
B | ef | 22000 |
C | abc | 14000 |
C | def | 28000 |
C | ghi | 42000 |
C | jkl | 38000 |
C | mno | 5000 |
TOTAL | 237000 |
Please see the attached file for the solution. Hope this helps..
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.
Thanks
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:
I did put something together based on the %, I think now you will be in position to take it forward based on your 80 -20 approach. Hope this helps...