Top 5 Products by Market Share - Stacked Bar Chart

[Anonymous]

I have a stacked bar chart which i want to show the top 5 products by market share for each year.  I am failing to format the table so that it shows the top 5 products by market share for the various years in the data set.  An example application is attached. Please assist.

[maxgro · Accepted solution]

maybe with this expression

if(rank(Sum([MedAid Amount]+Shortfall)/Sum(TOTAL([MedAid Amount]+Shortfall))) <= 5,

Sum([MedAid Amount]+Shortfall)/Sum(TOTAL([MedAid Amount]+Shortfall))

)

[Anonymous]

Many thanks Maxgro, will use this and advise you accordingly

Regards.

[Anonymous]

Hi Maxgro

Kindly post the sample application as i am having trouble in reproducing your recommendations.

Regards.

[maxgro]

PFA

[Anonymous]

Thank you Maxgro most appreciate