[Cloud Contributions: 0Level 1☆]

Hi,

Please can you help me? I need a report to show me 20% of products that bring in 80% of the business. I have no idea how to go about this.

Thanks
This is a cached copy. Click here to see the original post.

[dmashburn3 Contributions: 0Level 1☆]

The Pareto Principle! Unfortunately there is no easy way to do this EXACTLY in Netsuite. Saved searches nor reporting allow you to calculate this running total in a column while also looking for your item sales.

Reporting does have a nifty feature that allows you to add a % of Total Column as pictured here. This will allow you to see each item’s percentage contribution to the whole. Depending on your product line, you can either then do some quick head math down the column to figure out at one point they add up to 80% of sales, or you can dump it in excel and add a column to calculate a running total of the percentage to see when it hits 80%.

Note: The Pareto principle states that for many events 80% of the effects come from 20% of the causes. In business this is perhaps an ideal case (not true for all situations), but running this report does not necessarily mean that it will “show” you that the rule holds true for your business. Once you run it and find the products making up 80% of your sales, you may have more or less than 20% depending.

[Cloud Contributions: 0Level 1☆]

Hi,

Sorry I’m having a HARD time finding this report please can you tell me which Report you selected.

Thanks

[k_dunc Contributions: 0Level 1☆]

The report that dmashburn3, used was a Sales by Item report. Go to Reports > Sales > Sales by Item.

[dmashburn3 Contributions: 0Level 1☆]

Thanks for clarifying k_dunc. I’ve been toying around with the idea of using a saved search to actually perform the entire part here.

Perhaps michoel could provide some more info about how he used this formula from a blog:

Originally posted by michoel

View Post

See this article:

http://blog.prolecto.com/2015/05/26/…lly-challenge/

I have successfully used this technique to create a SOH running total report, as follows

Code:
SUM /* comment */ ({quantity}) OVER(ORDER BY {trandate} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
Note that the comment in the formula is required..

Could this be used in the same manner to perform other functions that are normally excluded from saved searches? Such as perhaps while calculating item sales, passing the totals to a percentage that is calculated as a running total?

Thanks

[michoel Contributions: 0Level 1☆]

dmashburn3, I am no Oracle expert but I would assume this technique could be used to access other analytic functions. It looks like the RATIO_TO_REPORT function may be what you are after.

https://docs.oracle.com/cd/B19306_01…nctions124.htm

http://www.techrepublic.com/blog/the…tio-to-report/

BTW, I believe the author of that blog post, Marty Zigman is active on this group – perhaps he can chime in with his thoughts.

[dmashburn3 Contributions: 0Level 1☆]

I’ve gone through and read Marty Zigman ‘s blog. It is one heck of a resource for new ideas and some really cool tips and tricks!

I’ll start passing some new analytic functions today and see what I can get. This feels like a giant door of possibilities for other functionality as well.

[Cloud Contributions: 0Level 1☆]

Wow Guys! That you’re looking into this deeper for me. I agree Marty @Zigman’s blog is outstanding but unfortunately I’m not developer so don’t understand any of it lol.

Anyway I’m sorry I was away for a couple of days but I’ll have a go now k_dunc and of course your screenshot dmashburn3

[Author]

Posts