This content has been marked as final. Show 5 replies
Is there a way, with a formula, to get the number of items (count distinct of a field) that makes the 80% of sales (sum of sales field ordered top-down)?
For example, if I have:
500 (Product 01) + 300 (Product 03) = 800, that is the 80% of total Sales field, this means that result is 2 (count distinct of Product 01 and Product 03).
By searching in the community I've not found anything to get the result...
Many thanks in advance!