cost distribution using aggr

[adamdavi3s]

Hi All,

Trying to create a cost distribution but aggregating the data.

I've attached my workings but I can't quite figure out the formula to use.

Note that in this file I have done a resident load to show you what I am trying to achieve but in reality this isn't feasible, it needs to work from formula on the raw data somehow.

I just can not sus it out

[swuehl · Accepted solution]

Try to aggregate your cost in the advanced aggregation and perform a distinct count in the expression:

=aggr( round(sum([TOTAL COST])/500)*500 ,CUSTOMER)	=count(DISTINCT CUSTOMER) / count(DISTINCT total CUSTOMER)
	100%
0	27%
500	36%
1500	27%
2000	9%

[adamdavi3s]

I got so close to that yesterday! Not sure why I couldn't figure that one out,  thank you swuehl