Help with aggregation for PARETO analysis

[#1]

Hi,

I'm making an analysis on customermix and would like to show the % share of total revenue that the top ten customers represent each month.

It indicates how well diversified our customer portfolio is and how it evolves in time.

So in the X axis I want to show the Months and in the Y axis a % share

In the excel file attached I try to show you what I need.

I manage to calculate the % share of top 10 customer revenue compared to total customer revenue but I don't succeed in varying it by month (e.g. value by month) in one chart.

Has anyone done similar analysis or has any suggestions?

Thanks,

[#2]

Hi,

You can do it using some functions. The proper synthax to find the TOP 10 customer by month is to create a new dimension as :

=if(aggr( rank( sum(Revenu)) , Month , Customer) <= 10 , Customer,null())

See the example (but only with the TOP2). The data are your data, except one row where I changed a value to have customer C ahead in march.

I add a button with Pareto analysis which could be useful for you. In my example, i select the customer who made 50% of the overall revenu.

Happy new year

JJ