Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
i want to calculate the best seller.
I have:
sales,
seller,
products.
What's the right formula?
For, product-wise calculation, try with a small correction to the above expression (by @dplr-rn ), like:
firstsortedvalue(seller,-aggr(sum(sales),product, seller))
Try like:
FirstSortedValue(seller, -Aggr(Sum(sales), seller))
need more details (what kind of visual, what are the dimensions etc.) for a proper answer but roughly you need
aggr function and firstsorted value
assuming you aresomething like firstsortedvalue(seller,-aggr(sum(sales),product)) to get best sales person per product
check this for a tutorial
For, product-wise calculation, try with a small correction to the above expression (by @dplr-rn ), like:
firstsortedvalue(seller,-aggr(sum(sales),product, seller))
I would like to have it in a KPI but it isn't a numeric value.
And the formula doesn't work.