Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For some time I have been trying to figure out how to calculate a pareto for sales.
I have a sales table:
InvoiceDate | ProductId | ProductGroup | SumOfSales |
date1 | productid1 | productgroup1 | 100 |
... | ... | ... | ... |
I would like to check:
1) How many products generate 80% of sales for a given day?
2) How many products generate 80% of sales for a given day and a given product group?
Can you suggest the easiest way to count it?
Have you already checked this?
Thanks! I will check!
I see there is the chart. I need a table with the result.
1)
Date | Number of product (generate 80% sal.) |
... | ... |
2)
Date | ProductGroup | Number of product (generate 80% sal.)* |
... | ... | ... |
*for each day and each group
Logic stays the same for Table or chart
Thanks, I used the formula and it seems to work.
But I need a different result (count). And I don't really have an idea how to change it.
I must have:
1) How many products make 80% of sales every day?
2) How many products in a given group make 80% of sales on a given day?
PS. On a large amount of data this formula (Pareto class) is converted quite a long time - which can be tedious.
You will have to share some data where we can see what you have. It would also help to know the output you expect to see from the sample data shared
I attach a sample data.
Based on this sample, what exactly are you looking to get? specific numbers based on the input file will make it easy to understand
@qlikeers wrote:Thanks! I will check!
I see there is the chart. I need a table with the result.
1)
Date Number of product (generate 80% sal.) ... ...
2)
Date ProductGroup Number of product (generate 80% sal.)* ... ... ...
*for each day and each group
Btw.
=Aggr(
If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.8, 'A',
If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.9, 'B',
'C')),
(Product,(=Sum({1} Sales),Desc))
)
Does not include the day (and any groups).
And is it possible to count it directly in LoadScript?