
1. Re: Binned sum of revenue based on rank percentile
Yuriy Fal Feb 9, 2019 7:53 PM (in response to Thrennial)Hi Thrennial,
Could you please share a workbook?
It could help others to help you.
Yours,
Yuri

2. Re: Binned sum of revenue based on rank percentile
Jim Dehner Feb 10, 2019 4:18 AM (in response to Thrennial)Good morning
Agree with Yuri   but I have done this sort of analysis before  in my application I looked at superstore sales at the state level and year  it takes some work so I will just so your
directionally where to go
the first thing you is determine the percentile boundary for each group with a formula like this  you will need 5  1 for each percentile group
{ EXCLUDE [State]: sum({ INCLUDE [Category]: (PERCENTILE( { INCLUDE [State],year([Order Date]),[Category]:sum([Sales])} ,.8) )})}
then the group definitions become
if ([fixed sales at state year cat])<sum(([percentile .2])) then 'Group 1'
elseif ([fixed sales at state year cat])<sum([percentile .4]) then 'Group 2'
elseif ([fixed sales at state year cat])<sum([percentile .6] )then 'Group 3'
elseif ([fixed sales at state year cat])<sum([percentile .8] )then 'Group 4'
elseif ([fixed sales at state year cat])<=sum([percentile 1.0]) then 'Group 5'
else 'other' end
you should be able to take that and get going on your analysis 
if you run into trouble post your book and one of us will help you out
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.