I want to calculate (not via Pareto) in crosstab how many customers contributed 80% of total sales
Hi Salini- Can you please share a bit more context? Sounds like you may want to create a calculated field OR use a filter to show only only those customers with total_sales >= .8
Let me know the specifics and I can make a recommendation. Thanks!
Hey,
Thanks for responding me!
I need to display the count of customers generating 80% of gross revenue.
I tried to create a calculation for 80 percentile and if Gross Revenue > 80 percentile then count of customers.
But if I create a percentile calculation its giving me a wrong result.
percentile({Gross Revenue}, 80, [truncDate(‘WK’,{date})])
Try going to the field well and changing the aggregate to percentile
Hi @Salini ,
I am guessing you would like this sorted by customer revenue? IE: you will need a field that breaks up customer revenue into groups?
You can do that with something similar to this (rounded by 1000’s)
round({Revenue}/1000)*1000
Add that to your chart (sorted)
You can create a calculated field for the running sum using the following
runningSum(YOUR REV CALC HERE/sumover(YOUR REV CALC HERE,[]),[YOUR REV GROUP ASC],[])
add it to your table and also filter that table using that calc > 80%.
Please let us know if this helps.
Hi Todd, this doesn’t work for me.